Can you transfer only highlight color from one file to another?

Hey all. I’m trying to figure out how to save myself A LOT of time every month. I currently work off of a pretty lengthy report that I need to rerun every couple of weeks. Each row is a different “project” for me so it’s important that I have these highlighted colors that mean something from a quick glance. Some will show up on the next report and some will not. When I rerun the report I lose all my highlights and manually have to compare the sheets and make the highlights match.

This may be a long stretch, is there a way to recognize the data from original report and apply the highlights to new report? If it helps provide information- these are exported into excel as separate files.

For example- old sheet has Smith in green, Doe in orange Johnson in grey (grey will not show up on new report sheet) and Jones un-highlighted. Can I grab highlights from old sheet and put them on new sheet so smith Doe and jones will have the correct highlight colors?