Conditional Formating question [Solved/Closed]

Report
Posts
2
Registration date
Wednesday June 8, 2016
Status
Member
Last seen
June 8, 2016
-
Posts
2
Registration date
Wednesday June 8, 2016
Status
Member
Last seen
June 8, 2016
-
Hi I need help with changing the color of a cell based on the Text values in the cells below it. So say B1 is the cell i want to change. B2-B7 has text values 'Yes', 'No', 'In Progress' I want to set this up so if 4 out of 6 has 'No' B1 changes to a red color and vice versa if 'Yes' It changes to green. Can someone help me with this?

1 reply

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
Select cell B1 then add the rules below.

For the Green:
=COUNTIF($B$2:$B$7,"Yes")>=4

For the Red:
=COUNTIF($B$2:$B$7,"No")>=4
Posts
2
Registration date
Wednesday June 8, 2016
Status
Member
Last seen
June 8, 2016

Thanks this is perfect

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!