I know this is simple but nothing I've tried is working. I have 3 cells, lets say
A1,A2,A3
A1= a entered date
A2= a formula to add 30 days to the date in A1 and display that date
I need A3 to change cell background color when the date in A2 = todays date. There is text in A3 that needs to remain.
Thank you
Bookmarks