Maybe

=B4<51% for red
=AND(B4=51%,B4<75%) for orange
=B4=75% for green


--
Regards!
Stefi



€žgashman€� ezt Ã*rta:

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.