Hello I am a new poster and have had a issue getting my conditional formatting to work correctly.
What I am attempting to accomplish:
Column/Row I2:AA2 to shade based on value in H2. Value 1-5 Green, 6-10 Yellow, 11-15 Orange, >=16 Red
The formulas I used are:
=IF($H2<=5,TRUE,FALSE) Applies to =$I$2:$AA$2
=IF(AND($H2>=6,$H2<=10),TRUE,FALSE) Applies to =$I$2:$AA$2
=IF(AND($H2>=11,$H2<=15),TRUE,FALSE) Applies to =$I$2:$AA$2
=IF($H2>=16,TRUE,FALSE) Applies to =$I$2:$AA$2
I have a value in H2 of 16 but the conditional formatting is not being applied??
Bookmarks