in the conditional formatting dialog, choose the option "Formula" in the
dropdown and enter =A2-NOW()<2
which obviously applies to cell A2 only.... Note that you can use the format
painter to copy this to other cells.

"figvm" wrote:

I have a simple spreadsheet with due dates. Is there a way to make the due
dates turn green when they are 2 days out from current date (Today) ? I have
office 2007.

Thank you!