Hi,
I’ll be damned if this doesn’t get me EVERY. SINGLE. TIME. Ugh! OK - enough complaining.
I have a table. There is a start date in column “E” and an end date in column “F.”
I’d like to add conditional formatting to highlight a row based on those dates.
RED - if the end date (column F) is within 10 days (before) Today()
YELLOW - if the end date (column F) is from 30-10 days before Today()
Sometimes the end date is blank. If it’s blank, I’d also like to add a format to that (so I follow up to get the end date).
Thanks in advance!
Judi
I’ll be damned if this doesn’t get me EVERY. SINGLE. TIME. Ugh! OK - enough complaining.
I have a table. There is a start date in column “E” and an end date in column “F.”
I’d like to add conditional formatting to highlight a row based on those dates.
RED - if the end date (column F) is within 10 days (before) Today()
YELLOW - if the end date (column F) is from 30-10 days before Today()
Sometimes the end date is blank. If it’s blank, I’d also like to add a format to that (so I follow up to get the end date).
Thanks in advance!
Judi