Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formats to ignore blank cells
For some reason this doesn't appear to be working...None of the colors are
showing up. Just to clarify, I do have cell with value less than or equal to 0 showing up, I just want the formating to ignore the blank cells. When using your suggestions, I am selecting a FORMULA instead of a CELL VALUE...is that okay? -- mnwankpah "Max" wrote: You could use eg an AND(D10, ...) construct to exclude blank cells which are evaluated as zeros. For example, apply the CF on col D using the formulas Cond1: =D130 Format: Red Cond2: =AND(D120,D1<=30) Format: Amber Cond3: =AND(D10,D1<=20) Format: Green -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "mnwankpah" wrote: I am trying to apply a conditional format to a pivot I created. If the value in the cell meets, exceeds or is below the target it should light up to the colors of a traffic light. How can I have the conditional format ignore blank cells? Right now it is highlighting all blank cell (as well as the title column) as a color for low target? -- mnwankpah |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formats to ignore blank cells
=AND(A1<"",your formula)
"mnwankpah" wrote: For some reason this doesn't appear to be working...None of the colors are showing up. Just to clarify, I do have cell with value less than or equal to 0 showing up, I just want the formating to ignore the blank cells. When using your suggestions, I am selecting a FORMULA instead of a CELL VALUE...is that okay? -- mnwankpah "Max" wrote: You could use eg an AND(D10, ...) construct to exclude blank cells which are evaluated as zeros. For example, apply the CF on col D using the formulas Cond1: =D130 Format: Red Cond2: =AND(D120,D1<=30) Format: Amber Cond3: =AND(D10,D1<=20) Format: Green -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "mnwankpah" wrote: I am trying to apply a conditional format to a pivot I created. If the value in the cell meets, exceeds or is below the target it should light up to the colors of a traffic light. How can I have the conditional format ignore blank cells? Right now it is highlighting all blank cell (as well as the title column) as a color for low target? -- mnwankpah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ignore blank cells in function | Excel Discussion (Misc queries) | |||
ignore blank cells | Excel Discussion (Misc queries) | |||
How to ignore blank cells | Charts and Charting in Excel | |||
how do you ignore blank cells in formulas | Excel Discussion (Misc queries) | |||
how do you ignore blank cells | Excel Discussion (Misc queries) |