I'm trying to work with a huge Excel sheet that is auto updated and each time I have to open the new updated file. I have to review sales reps orders about three times a week. And I need it to be able to highlight or sort by a set list of sales rep names that I keep in a separate Excel sheet (if possible).

I've looked at conditional formatting, but I need to be able to include a list of 5-50 sales reps. Please let me know if there is any other information that is needed from me.

Thank you in advance for any help that you can provide!