Previous Topic Next Topic

Conditional formatting cell if every cell contains "YES"

Solved/Closed
Report
Posts
2
Registration date
Thursday April 30, 2015
Status
Member
Last seen
May 1, 2015
 -
Posts
2
Registration date
Thursday April 30, 2015
Status
Member
Last seen
May 1, 2015
 -
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

1 reply

Answer 1 / 1
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
 490
Hi Lizzy,

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

Best regards,
Trowa
4
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Report
Posts
2
Registration date
Thursday April 30, 2015
Status
Member
Last seen
May 1, 2015
Thanks a lot TrowaD! It works a treat. My mental health is restored!
Ask a question