| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional format -- if not a date, then highlight cell
How do I enter a conditional format to highlight the cell if it's not a valid
date? I tried "formula is": =if(not isdate(C10)) <if(isdate(C10)) Your help would be greatly appreciated!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional format -- if not a date, then highlight cell
I think I'd put some data validation on the field to ensure that it's a date
as well. -- HTH, Barb Reinhardt "laavista" wrote: How do I enter a conditional format to highlight the cell if it's not a valid date? I tried "formula is": =if(not isdate(C10)) <if(isdate(C10)) Your help would be greatly appreciated!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format to Highlight the Active Cell | Excel Worksheet Functions | |||
| Conditional Format to Highlight entire Row? | Excel Worksheet Functions | |||
| Conditional Format to highlight blank cell | Excel Worksheet Functions | |||
| conditional formatting highlight the cell today's date | Excel Programming | |||
Hybrid Mode
