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.