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
Related:
- Conditional Formating question
- Yahoo mail forgot password and security question - Guide
- Conditional formatting if two cells match ✓ - Excel Forum
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
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