So I have been given the task of creating an excel table in 03 that needs to
do a couple of things and I am new to excel and not good at formulas:

First: when a date is entered into Column E i need a 5 day countdown to
return a color change in corresponding row in column A
Day 1= Blue
Day 2= Purple
Day3=Yellow
Day 4=Orange
Day 5 = Red

Second: when any date is entered into Column G i need the corresponding Row
in Column A to turn Green and overtake the first rule and stay green
permanently

any help would be grateful!