I have an excel with Weekly Pick Em's for bunch of co-workers, I want to use a conditional formatting to automatically highlight people with the correct pick. I'll type in the "Winning Team" for Column "B" and so I want it to color in green anyone that selected that team for their picks. Please see attachment for example.
ExampleWeeklyPickEms.png
Bookmarks