In . com, Udo
spake thusly:

as Excel only accepts three conditions for cond. formatting, you
have to use a VBA solution:

Code looks good to me at a glance, but really, he did only have three
conditions. He *called* them 5, but they are three:

3) Below are the 5 conditions
a) 25 to 35 % - Interior colour green and font colour white
b) 20% to 25 % - - Interior colour gold and font colour white
c) 35 to 40% - - Interior colour gold and font colour white
d) below 20 % - - Interior colour red and font colour white
e) above 40%- Interior colour red and font colour white

Cell value =OR(<20%,40% red/white
Cell value =OR(<25%,=35%) gold/white
Cell Value =<=40% green/white

I *think* I got that right ...

-dman-