One method is to go to Conditional Formatting, then Manage Rules. Use New Rule three times, once for each name you want to match. Because you want to format a cell other than the one with the value you are checking, you should use "Use a formula to determine which cells to format" and it will reference $A1. Then you can copy the formatting to other cells and the relative part of the reference will be copied correctly, just as when you copy formulas with relative references to other cells.
Bookmarks