Conditional formatting cell if every cell contains "YES"

Solved/Closed

LizzyDashwood Posts 2 Registration date Thursday April 30, 2015 Status Member Last seen May 1, 2015 - Apr 30, 2015 at 10:18 AM
LizzyDashwood Posts 2 Registration date Thursday April 30, 2015 Status Member Last seen May 1, 2015 - 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

If cell contains specific text
How to find specific words on a page - Guide
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
If cell contains date then return value ✓ - Excel Forum
Excel "IF" function w/ date in test cell ✓ - Excel Forum
Excel formula to check if cell contains a date - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Apr 30, 2015 at 11:17 AM

Hi Lizzy,

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

Best regards,
Trowa

LizzyDashwood Posts 2 Registration date Thursday April 30, 2015 Status Member Last seen May 1, 2015
May 1, 2015 at 03:36 AM

Thanks a lot TrowaD! It works a treat. My mental health is restored!

Similar discussions

Highlight cell if another cell contains specific text

How to use conditional format based on text?

If a cell contains any text then add a value

Counting cells containing only numbers

If cell = date return yes or no.

Similar discussions

Subscribe To Our Newsletter!