To really simplify my problem lets put in column A YES YES NO YES. In column B Mike Sarah Paul Jane.
Is it possible to use a conditional format on cells B1:B4 to be green if cell A1:A4 = YES? So in the above example Mike, Sarah and jane would be in green text/fill but Paul would stay base colours.
I know I could set a format for each individual B column cell, but I have a very long list. This is just a simple example of what I want to achieve.
Edit:
An alternative would be to have "YES" in C1 then condition format 'If A1 = $C$1 then B1 is green. If A2 =$C$1 then A2 is green, and so on.
Bookmarks