Conditional formatting cell if every cell contains "YES" [Solved/Closed]

LizzyDashwood 2 Posts Thursday April 30, 2015Registration date May 1, 2015 Last seen - Apr 30, 2015 at 10:18 AM - Latest reply: LizzyDashwood 2 Posts Thursday April 30, 2015Registration date May 1, 2015 Last seen
- May 1, 2015 at 03:36 AM
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
See more 

2 replies

Best answer
TrowaD 2391 Posts Sunday September 12, 2010Registration dateModeratorStatus July 12, 2018 Last seen - Apr 30, 2015 at 11:17 AM
4
Thank you
Hi Lizzy,

Try the following formula:
=COUNTIF($C1:$F1,"Yes")=4

Best regards,
Trowa

Thank you, TrowaD 4

Something to say? Add comment

CCM has helped 1706 users this month

LizzyDashwood 2 Posts Thursday April 30, 2015Registration date May 1, 2015 Last seen - May 1, 2015 at 03:36 AM
Thanks a lot TrowaD! It works a treat. My mental health is restored!