I need to make it so the dates in the date column will automatically format the cells as below.
No Date in Cell = Blank
Date within 2 weeks = Yellow
Date Over 2 weeks = Green
Date within one day, or overdue = Red
Please look at the cosmetics of the color formatted cells. I would like it to match what I have there.
Solved by E. E. in 23 mins