I have a column of dates, I would like to have the cell turn color when the
date in the cell is older than the current date. Is there a way that this can
be done? This would easyly allow me to identify all past due accounts.

select your data and do Format=>Conditional Formatting

see help on conditional formatting and also


Debra Dalgleish
http://www.contextures.com/tiptech.html

look under C for conditional formatting.

--
Regards,
Tom Ogilvy



"Prohock" wrote:

> I have a column of dates, I would like to have the cell turn color when the
> date in the cell is older than the current date. Is there a way that this can
> be done? This would easyly allow me to identify all past due accounts.
>
>