Formula not working, help
 

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.

Formula not working, help
 

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.

Formula not working, help
 

Hi,

Select the range M3 - M544 and use this CF formula

=AND(M30,M3<"Exempt")

Mike

"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.

Formula not working, help
 

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

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


Gord

On Wed, 11 Mar 2009 13:48:43 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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.