conditional format -- if not a date, then highlight cell

  • Thread starter Thread starter laavista
  • Start date Start date
L

laavista

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!!
 
I think I'd put some data validation on the field to ensure that it's a date
as well.
 
Back
Top