Conditional Formating question

Solved/Closed

sforde

Posts: 2
Registration date: Wednesday June 8, 2016
Status: Member
Last seen: June 8, 2016

- Jun 8, 2016 at 03:15 PM
sforde

Posts: 2
Registration date: Wednesday June 8, 2016
Status: Member
Last seen: June 8, 2016

- Jun 8, 2016 at 04:09 PM

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?

Conditional Formating question
Conditional Formatting Question ✓ - Forum - Office Software
Conditional formatting if cell does not contain specific text ✓ - Forum - Excel
Conditional formatting if another cell contains any text ✓ - Forum - Excel
Excel conditional formatting 5 color scale ✓ - Forum - Excel
Copy conditional formatting from one row to another ✓ - Forum - Excel

1 reply

Answer 1 / 1

RayH

Posts: 122
Registration date: Tuesday August 31, 2010
Status: Contributor
Last seen: June 20, 2016

25
Jun 8, 2016 at 03:45 PM

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

Posts: 2
Registration date: Wednesday June 8, 2016
Status: Member
Last seen: June 8, 2016

Jun 8, 2016 at 04:09 PM

Thanks this is perfect

Subscribe To Our Newsletter!