Conditional Formatting for Upcoming Dates
Hello all!
I am relatively new to Excel/Google Sheets and am wanting to do a little "automating" for my job that makes it easier for me to spot due dates and potential due dates. My overall goal is to have cells be highlighted at certain colours when they hit certain time intervals past a date in a cell. For example; if I have E63 at a certain date, I want to be able to have E63 turn green after 7 days has passed since that date (05/19/2026), orange after 12 days, and red after 14 days. I would only be doing this to the dates that are on the furthest part of each row. Nothing before that row.
I have already tried to google and Youtube this answer and any custom formula I try just is not seem to be working. I am thinking that either the initials that are in the cell are causing the screwup, or I am not formatting the dates right.
https://docs.google.com/spreadsheets/d/1qjl46vQzgi_Vw3yMrgUsVoOm6tO-wtg2/edit?usp=sharing&ouid=104042642632983553883&rtpof=true&sd=true This is the link to the original spreadsheet!
My formulas I am using here are:
=E63>=Today()+7, =E63>=Today()+12, =E63>=Today()+14
Any thoughts would be appreciated!
P.S Maybe =NOW()>E63+7 would work?
Thank you to @HolyBonobos for the help already!