Excel 2007 IF Function

[a6lq1]

did u name the Quota and Bonus using range name? i think u gotta mention that first :)

thanks for the gr8 work!!

[Romblu3]

Tanks for the invaluable help !

[OfficeSavant]

Virgo -- In '07, Select the cells for the "Conditional Format", Home Tab, Styles Group, Conditional Format down delta (the triangle), HIghlight Cell Rules, Equal to "Yes", from the drop down above the Cancel button sleect Red Text

OfficeSavant