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!

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!

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!

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!

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!