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


--
Jonibenj
------------------------------------------------------------------------
Jonibenj's Profile: http://www.excelforum.com/member.php...o&userid=17048
View this thread: http://www.excelforum.com/showthread...hreadid=478095