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