Script to interrogate the current system time

[matpj]

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?

[Peter T]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>