IF Equation?

[cjgodfrey37]

I have a worksheet that has rows labeled for my employee and columns labeled for percentages. The last column is an average of sales conversion week to day. I would to format three boxes for the colors the company uses to how percentage of sales:

Red - 16.9% and below
Yellow - 17.0% to 19.9%
Green - 20% and above

I would like to be able to do the following:

1. If AF (the final column for week total) = <16.9% then the name of the employee would show up in the yellow box
2. IF AF = 17.0% to 19.9% the name of the employee would show up in the yellow box
3. IF AF = 20.0% and above the name of the employee would appear in the green box

Does anyone know if this is possible. As the database is updated the names would automatically in the color box it goes to. Thank you!!

[venkat1926]

attach(facility available in this newsgroup) small extract of your data