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
Bookmarks