Highlighting dates in a cell relative to the TODAY()

  • Thread starter Thread starter Steve HKG
  • Start date Start date
S

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!
 
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
 
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
 
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
 
Back
Top