On Thu, 20 Oct 2005 19:35:35 -0500, Jonibenj
wrote:


I have a list of items which have expiry dates. I want these dates
compared to the current date every day, and some sort of formatting
applied when they are due this month, or overdue. I believe this can
be done with conditional formatting (which I have used before), but I
don't know how to construct the formula to compare each cell to the
present date.

Jonathan

Format/Condtional Formatting

Cell Value Is: Less Than =TODAY()-30

as an example.


--ron