I am looking for the best way to do this. I have a spreadsheet where a date something is received is entered in column A and the date it goes back out is in column G. I need to have the cell in G turn green if the date entered is within 7 days of the date in column A and turn red if it is 8 days or later. (hope that all makes sense)
I have tried browsing through multiple thread and can't seem to get it right. Can anyone please help?
Bookmarks