See this:

http://groups.google.com/group/micro...cf859ecd?tvc=2

--
Biff
Microsoft Excel MVP


"RingDing" wrote in message
...
I have a spreadsheet where it contains a lot of date formulas, but I need
to
see when I hard key a date. How do I conditional format for that?