Hello,
I want to A2 (surname) and B2 (forename) to turn green if every cell in range C1:F1 equals "yes". At the moment it is highlighting A2 & B2 if only one of the cells in the range ="yes".
I can't figure out what I'm doing wrong. This is the most recent formula I have tried
=$F2:$I2="YES"
I then use format painter to apply to all cells
Thanks
L
Related:
Conditional formatting cell if every cell contains "YES"