L
Leona
I'm trying to get a cell color coded (B36) based on a formula result in
another cell (H3), based on several different parameters, i.e.:
If H3>60, I want cell B36 background to turn green
If H3 <=60 AND => 30, I want cell B36 background to turn yellow
If H3 <30, I want cell B36 background to turn red
I've tried multiple conditional formatting, IF functions, and simple
formulas and nothing seems to work -- I don't get any color formatting no
matter what formula variation I try.
Any suggestions?
another cell (H3), based on several different parameters, i.e.:
If H3>60, I want cell B36 background to turn green
If H3 <=60 AND => 30, I want cell B36 background to turn yellow
If H3 <30, I want cell B36 background to turn red
I've tried multiple conditional formatting, IF functions, and simple
formulas and nothing seems to work -- I don't get any color formatting no
matter what formula variation I try.
Any suggestions?