Hi,

I am working on a business development spreadsheet in work.

Column A = Name of contact
Column E = Date of last contact (in date format dd/mm/yy)

I want column A to:

Turn green if I contacted the person between 0 - 30 days ago
Turn yellow if I contacted the person between 31 - 60 days ago
Turn red if I contacted the person over 90 days ago

Is there a way I can have the colours change dependent on when I update the spreadsheet to change the "Date of last contact" column?

Thanks in advance,
Ash