You could use Conditional Formatting

Select the first cell of your dates (in this example A1)

Formula Is :

=A1<TODAY()

=A1=TODAY()

maybe format red for the first condition and amber for the second

PasteSpecial formats to other dates

If your date includes time, ie value includes a decimal for hh:mm:ss, you
might need INT(TODAY())

Regards,
Peter T

"matpj" wrote in
message ...

I have some VBA that calculates the quantity of time that is required to
be entered and when.
This uses a table of release dates for various products.
I am producing a spreadsheet that will contain a simple list of project
number, time required and dates required.
What I would like to do is have my system check the dates on this
spreadsheet every morning, and alert me if any of the dates on the
spreadsheet are equal to the system date.

does that sound possible?
if so, can anyone suggest how?


--
matpj
------------------------------------------------------------------------
matpj's Profile:
http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=506343