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

Question

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

Report

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

Conditional formatting cell if every cell contains "YES"
How to count conditionally formatted cells in excel - Forum - Excel
Excel conditional formatting if cell contains any date - How-To - Excel
Conditional formatting merged cells ✓ - Forum - Excel
Conditional formatting if cell contains any text ✓ - Forum - Excel
Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Accepted Answer · 2015-04-30T11:17:29-0400

Answer 1 / 1

TrowaD

Posts: 2700
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: February 25, 2021

457
Apr 30, 2015 at 11:17 AM

Hi Lizzy,

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

Best regards,
Trowa

Report

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!

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

1 reply

Your reply

Subscribe To Our Newsletter!