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!