Highlight row 3
in CF:
1st condition cell value is: 0.90 ... set to green
2st condition cell value is: between 0.70 and 0.90 ... set to yellow
3rd condition cell value is: < 0.70 ... set to red

HTH


"rook" wrote:

Can someone show me how to provide conditional formatting for the following:


A B C D E
1 Jan-07 Feb-07 Mar-07 Total
2 forecast 5 8 10 23
3 % comp 22% 35% 43%
4 goal 33% 67% 100%
5
6
7
8 Green 90%+
9 Yellow between
10 Red 70%-


Applying the formatting to the items in row 3. Thanks for your help.