Conditional Formating question
Solved/Closed
sforde
Posts
2
Registration date
Wednesday 8 June 2016
Status
Member
Last seen
8 June 2016
-
8 Jun 2016 à 15:15
sforde Posts 2 Registration date Wednesday 8 June 2016 Status Member Last seen 8 June 2016 - 8 Jun 2016 à 16:09
sforde Posts 2 Registration date Wednesday 8 June 2016 Status Member Last seen 8 June 2016 - 8 Jun 2016 à 16:09
Related:
- Conditional Formating question
- Excel conditional formatting based on date - Guide
- Gmail security question - Guide
- How can i recover my yahoo account with security question - Guide
- What is your mother maiden name security question - Guide
- Nested conditional statements in excel - Guide
1 response
RayH
Posts
122
Registration date
Tuesday 31 August 2010
Status
Contributor
Last seen
20 June 2016
26
8 Jun 2016 à 15:45
8 Jun 2016 à 15:45
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
8 Jun 2016 à 16:09