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
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?
Related:
- Conditional Formating question
- How can i recover my yahoo account with security question - Guide
- Google recovery password security question - Guide
- How to type question mark on laptop keyboard - Guide
- Excel conditional formatting based on date - Guide
- How to do upside down question mark on mac - Guide
1 response
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Jun 8, 2016 at 03:45 PM
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
For the Green:
=COUNTIF($B$2:$B$7,"Yes")>=4
For the Red:
=COUNTIF($B$2:$B$7,"No")>=4
Jun 8, 2016 at 04:09 PM