| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format Based on Age, but not if blank.
I was to apply conditional formating to a cell. In that cell is a date,
formatted as 3/28/2008. The Conditional Formating should look at the date, if that date is 180 days or more in the past, it should fill the cell with yellow. If the cell is blank, it shouldbe left as is. I have gotten the 180 day part to work with "Cell value is, less than or equal to, =(TODAY()-180)" But a blank cell is also "less than or equal to". How can I make it leave a blank cell alone? -- Thank you, Gregory |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting:highlight row based on blank or non-blank c | Excel Worksheet Functions | |||
| Conditional format - blank vs. 0 | Excel Discussion (Misc queries) | |||
| Conditional Format A Cell If Row Is Blank | Excel Discussion (Misc queries) | |||
| Conditional format -blank | Excel Worksheet Functions | |||
| conditional formatting:highlight row based on blank or non-blank c | Excel Discussion (Misc queries) | |||
Threaded Mode
