I have one worksheet in a workbook with multiple names in one column... IE: Starting at Column A8 through A100
I have 14 names of people that I have placed in Column A on a separate worksheet within the workbook. What is need to do is format each cell that shows one of the 14 names in it. I know I can do this individually as it works, just don't no how to include all 14 names...
EXAMPLE: Column A If the Employee NAME in Column A matches one of the 14 MANAGER names in Column A on the sheet called MGR then highlight it light blue.
I want to do this with conditional formatting.
Thanks for any help in advance.
Bookmarks