format cells depending on value range
CF's are evaluated in order. As soon as a conditon is met it stops evaluating
so all you need is
Less than 51%
Less than 75%
Greater than or equal to 75%
--
HTH...
Jim Thomlinson
"gashman" wrote:
Using Excel 2003 and am trying to format cells depending on a range of values
e.g.
If the value is less than 50.999% then colour the cell red
If the value is between 51% and 74.999% then colour the cell orange
If the value is more than 75% then colour the cell green
I have managed to get the first and third examples to work using conditional
formatting (formula is: =B4<0.50999) but can't seem to get it to work if the
value is between two specific values.
Any help would be appreciated.
|