Conditional Formating question [Solved/Closed]

Question

Previous Topic Next Topic

Conditional Formating question [Solved/Closed]

Report

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
Copy conditional formatting from one row to another ✓ - Forum - Excel
Excel conditional formatting if cell contains any date - How-To - Excel

1 reply

Ask a question

RayH · Answer 1 · 2016-06-08T15:45:27-0400

Answer 1 / 1

RayH

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

24
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

Report

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

Conditional Formating question [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!