You cannot use a range of cells in that manner.

The CF must go on individual cells.

Select M3:M544 then CFFormula is: =AND(M30,M3<"Exempt")


Gord Dibben MS Excel MVP


On Wed, 11 Mar 2009 13:32:10 -0700, SunshineinFt.Myers
wrote:

I am using conditional formatting featu Using the Formula is in the
conditonal formatting: =AND(M3:M5440,M3:M544<"Exempt") This is not working.
Want to highlight those cells that have 0 but do not want to highlight empty
or the cells that have the word exempt. Need some help. Have been trying to
get this answered for a few days now.