Since your conditions cover all possible values of the cells you can "fake"
the 4th condition. Set conditional formats for condtions 2, 3, and 4. Make
the natrual fill color of the cells light blue.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"John Moore" wrote:

Hi, I am looking for a code which will do the following for me

Range is T5:T90
Condition 1: If Cell value is 10 make background light blue
Condition 2: If cell value is between -10% and -20% make background yellow
Condition 3: If cell value is < -20% make background red
Condition 4: If cell value is < 10% but 0% make background green.