Conditional Formatting based on tick boxes

R

rjwalker2514

New member
Joined
Aug 25, 2018
Messages
11
Reaction score
0
Points
0
Excel Version(s)
2016
Hi. There is a description of my problem in the attached excel doc

Cheers
 

Attachments

  • Book2.xlsx
    14.5 KB · Views: 12
In CF > new rule > use a formula > =AND(G8=TRUE,OR(E7<800,E7>1600)) select format > Ok
and for green the formula is
=AND(G8=TRUE,OR(E7>799,E7<1601))
Then modify them for the other checkbox
 
You must log in or register to reply here.
Back
Top