Highlighting dates in a cell relative to the TODAY()

[Steve HKG]

I have a table with dates and wish to show:-

1. The date IF it has pasted requires to be highlighted in RED colour;
2. The date IF it is between 1 and 30 days from today's date to be coloured
BLUE;
3. The date IF it is between 30 and 60 days from today's date to be coloured
GREEN;

By highlighting means that the text colour changes to the colour mentioned
above and the font changes to BOLD.

Many thanks!

 

[David Biddulph]

The facility you needd is Conditional Formatting. Look it up in Excel help.

 

[Per Jessen]

Hi

Conditional formatting will do what you need.

Select the date column, and goto Format > Conditional Formatting > Condition
1: Formula is >

=A2<Today()

Format as required. Click to add another condition (max 3 conditions) .

=And(A2>Today();A2<=Today()+30)

Condition 3:

=And(A2>Today()+30;A2<=Today()+60)

Regards,
Per

 

[Steve HKG]

Hi Per, thanks.

I have set it up and input the formulae as indicated in your reply, but
excel informs me that there is a error. I think in the line...

=And(A2>Today();A2<=Today()+30)

But am not sure what it could be. Sorry!

Steve

 

[David Biddulph]

If your Windows list separator is a comma instead of a semi-colon, change
the semi-colon in the formula to a comma.

But you don't need the AND functions.
You've already tested for A2<Today() in the first condition, so the second
can be =A2<=Today()+30 and the 3rd can be =A2<=Today()+60