Highlighting dates in a cell relative to the TODAY()
 

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!

Highlighting dates in a cell relative to the TODAY()
 

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

"Steve HKG" wrote in message
...
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!

Highlighting dates in a cell relative to the TODAY()
 

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(A2Today();A2<=Today()+30)

Condition 3:

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

Regards,
Per

"Steve HKG" skrev i meddelelsen
...
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!

Highlighting dates in a cell relative to the TODAY()
 

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(A2Today();A2<=Today()+30)

But am not sure what it could be. Sorry!

Steve

"Per Jessen" wrote:

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(A2Today();A2<=Today()+30)

Condition 3:

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

Regards,
Per

"Steve HKG" skrev i meddelelsen
...
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!

Highlighting dates in a cell relative to the TODAY()
 

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
--
David Biddulph

"Steve HKG" wrote in message
...
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(A2Today();A2<=Today()+30)

But am not sure what it could be. Sorry!

Steve

"Per Jessen" wrote:

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(A2Today();A2<=Today()+30)

Condition 3:

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

Regards,
Per

"Steve HKG" skrev i meddelelsen
...
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!