Hi,

First, it is not clear how you are using cell A1, you mention it at the
beginning of the post but never again?

Suppose you are going to put the critical dates in cells F1:F2 and you want
to format B2. Select B2, choose Format, Conditional Formatting, leave
between selected and click in the 3rd box, click on cell F1, then click in
the 4th box and click on cell F2. Click the Format button and pick your
color.

Every week you can specify the F1 and F2 dates or you can design a formula
to figure them out for you. I'm not entirely clear on what your conditions
are so I leave that to you.


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"grateful" wrote:

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