Thread: conditional format -- if not a date, then highlight cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
laavista laavista is offline
external usenet poster
  
Posts: 50
Default 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!!
Reply With QuoteReply With Quote