formula for Conditional formatting

[mrinal saha]

Hi folks,

this might be a simple one for you..I'm pretty new to 2007 and I want to enter the below formula in a cell to use the conditional Formating. There are multiple conditions for one cell.

=IF((E7)/(D7*MONTH(TODAY())-1/12)<0.85) Background color should be RED

=IF((E7)/(D7*MONTH(TODAY())-1/12)>0.85&<100) Color should be Amber

=IF((E7)/(D7*MONTH(TODAY())-1/12)=100) color green

thanks,,
Mrinal

 

[ganeshpoojary05]

Try this, check if it works:

=((E7)/(D7*MONTH(TODAY())-1/12)<0.85) Background color should be RED

=((E7)/(D7*MONTH(TODAY())-1/12)>=0.99) Color should be Amber

=((E7)/(D7*MONTH(TODAY())-1/12)=100) color green