I have a sheet on which i enter in a particular date into a cell. I want that
cell to change colour after 7 days has passed so next time i open excel up i
can see which dates have expired.

Also i want all of the dates that expire to come up in another sheet

Help on this would be great.

The conditional formatting can be achieved with a formula of say

=A1<TODAY()-7

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Condoodle" wrote in message
...
I have a sheet on which i enter in a particular date into a cell. I want
that
cell to change colour after 7 days has passed so next time i open excel up
i
can see which dates have expired.

Also i want all of the dates that expire to come up in another sheet

Help on this would be great.