Conditional Formatting with deadlines

[figvm]

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!

 

[Sheeloo]

Yes.

Select the cells you want to highlight
Click on Conditional Formatting on the HOME tab of the ribbon.
Choose Highlight Cell Rules
Choose a date occuring
Choose the condition and the format you want

or you may choose more rules and enter the condition you want

 

[rdwj]

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.

 

[rdwj]

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

 

[Shane Devenshire]

Hi,

To answer the specific question you asked

1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, New Rule
3. Choose Use a formula to determine which cell to format
4. In the Format values where this formula is true enter the following
formula:
=TODAY()-2=A1
5. Click the Format button and choose a format.
6. Click OK twice

If you want to do it for the two days before today then:

=OR(TODAY()-A1=2,TODAY()-A1=1)

Or if you want to format all date which are on or after Today-2 then

=A1>=TODAY()-2
would do.