I have a spreadsheet which consists of dates and coloured background
within the same cell.

If the dates have passed, then they have coloured backgrounds however
if the dates are in the future, then they are not coloured.

I am trying to think of a way in which I can use a macro to move alon
the cells looking for dates which have passed. If they have passed an
do not have coloured backgrounds, I need the macro to add a coloure
background.

Is there a way in which I can use a macro to colour in a background i
the date has passed but not colour it in if the background has a colou
and the date has passed?

Any help would be appreciated. Many Thanks.

Kiz

--
Message posted from http://www.ExcelForum.com