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

's Computer Specifications

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!!

's Computer Specifications

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!!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Custom or conditional format to highlight today's date?	Tonso	Microsoft Excel Discussion	4	3rd Apr 2009 05:44 PM
Conditional Format to Highlight the Active Cell	Pawprint	Microsoft Excel Worksheet Functions	1	30th Jul 2008 09:03 PM
Conditional Format to highlight blank cell	DaveMoore	Microsoft Excel Worksheet Functions	4	23rd Jun 2005 10:10 AM
Conditional format entire row (not cell) by date	Dave	Microsoft Excel Misc	4	7th Jan 2004 10:19 AM
conditional formatting highlight the cell today's date	tegger	Microsoft Excel Programming	5	16th Oct 2003 01:28 PM