Conditional Formating question
Solved/Closed
sforde
sforde
- Posts
- 2
- Registration date
- Wednesday June 8, 2016
- Status
- Member
- Last seen
- June 8, 2016
sforde
- Posts
- 2
- Registration date
- Wednesday June 8, 2016
- Status
- Member
- Last seen
- June 8, 2016
Related:
- 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
RayH
Jun 8, 2016 at 03:45 PM
- Posts
- 122
- Registration date
- Tuesday August 31, 2010
- Status
- Contributor
- Last seen
- June 20, 2016
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