Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Not Working | New Users to Excel | |||
Formula Sometimes Working Sometimes Not | Excel Discussion (Misc queries) | |||
Formula not working | Excel Discussion (Misc queries) | |||
Formula not working | Excel Worksheet Functions | |||
formula is not working | Excel Worksheet Functions |