Formula not working, help

[SunshineinFt.Myers]

I am using conditional formatting feature: Using the Formula is in the
conditonal formatting: =AND(M3:M544>0,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.

 

[Gord Dibben]

You cannot use a range of cells in that manner.

The CF must go on individual cells.

Select M3:M544 then CF>Formula is: =AND(M3>0,M3<>"Exempt")


Gord Dibben MS Excel MVP

 

[Mike H]

Hi,

Select the range M3 - M544 and use this CF formula

=AND(M3>0,M3<>"Exempt")

Mike

 

[Gord Dibben]

Or if the "empty" cells are returning a null string "" due to an IF
formula.

=AND(M3<>"",M3<>"Exempt")


Gord