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.