I have a column of data, most of which are dates formatted a
DD-MM-YYYY. However, some of the data are not formatted properly du
to being incomplete. For example, instead of DD-MM-YYYY, the cel
contains "June 2002."

I would like a macro that identifies these "bad" dates and colors th
cell red for every bad date found. Any help?

Thanks again everybody

--
Sandema
-----------------------------------------------------------------------
Sandeman's Profile: http://www.excelforum.com/member.php...fo&userid=3244
View this thread: http://www.excelforum.com/showthread.php?threadid=52566