Hi,

I would like to make the colour of the font change in a cell based on the
date.

In workbook 1 I have a date in Cell A1

In workbook 2 that date appears in cell B1

If today is Monday,December 15th, 2008 and the date in B1 is between
Tuesday, December 9th, 2008 and December 15th, 2008 than I would like that
date to appear "green" in workbook 2 cell B1

But if the date in cell B1 is before Tuesday December 9th, 2008 I want it to
appear in white.

The thing is the formula can't say specific dates, like December 15th, 2008
- Because every week the dates will change.

It needs to be the present Monday back to the past Tuesday.

The reason being: Between Thursday evening and Monday evening I have time to
update reports. They do not have to be updated for anyone until Tuesday
morning.
But, if I do have them done early, such as on Sunday night, I would like it
to be apparent in "green" that the info has been updated; so they can use
those figures on Monday if they open the report and see it "green".

If it is Monday and someone opens the report and the date is still the
Monday previous, it should be white...and then they will know not to use the
figures, they haven't been updated.

Can anyone help me with this?

Thank you so much.

If the date in B1

If the