Report

Conditional Formating question [Solved]

Ask a question sforde 2Posts Wednesday June 8, 2016Registration date June 8, 2016 Last seen - Latest answer on Jun 8, 2016 04:09PM
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?
See more 
Helpful
+0
moins plus
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
sforde 2Posts Wednesday June 8, 2016Registration date June 8, 2016 Last seen - Jun 8, 2016 04:09PM
Thanks this is perfect
Reply
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!