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!