Tom,

Use conditional formating with the formula is =$E$4-NOW()<=7 and then set
the pattern,
then add another =$E$4-NOW()<=21 and then set the pattern

--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"tommcbrny" wrote:

Hello,

I would like to format a "Status" cell to red, amber, or green depending on
how far a date entry in an "Estimated Date" cell is from the actual date (ie
today's date).

For instance, if the estimated date is 3 weeks or more in the future from
today, the status is green. If less than 3 weeks, but more than 1 week in
the future, amber. If less than 1 week in the future, red.
Is something like this possible?

Thank you,
Tom