CT,

Forget about formatting the default green - use your white, and use a third CF with the formula

=TODAY()<=(A2+90)

You can try Tools / Options Edit tab, check "Extend data range formats and formulas" That option
may work, if your columns F and A are 'connected' somehow. I don't find it to be reliable, so you
can fall back on just copying the formatting down the column - the cells will be white until one of
the conditions is met.

HTH,
Bernie
MS Excel MVP


"Custard Tart" wrote in message
...
Hi there,

Thanks for the help but I'm a little confused by a few of your steps
and have some further questions.

Select Cell F2, format the cell green,

Why would I format the cell green first and not choose it from the
"patterns" option when I enter the formula?

and format for amber

Am I adding another condition and another formula for this or do you
mean that the amber would then override the cell's normal green
colour?

Also, I'd like to know how to extend the formula for all of column A
to be included if anyone adds extra dates and for all of column F to
change based on this?

Is there a way for column F to start out as white rather than be green
by default?

Thanks for your help!
CT