I wanted to highlight an entire row based on the date in a column. Yellow if it's equal to today, Red if it's past 4 days from today, and Green if it's sooner than today.
I used these formulas and they worked:
=TODAY()=$M2 (Yellow)
=TODAY()+4>=$M2 (Red)
=TODAY()<=$M2 (Green)
Only problem is that I want the rows to remain blank if there is nothing in the M column and they all appear red. The column has a formula K2+L2 (Where column K is the date where an invoice is sent and column L are the net terms) and the default date that appears is 1/0/00. All those rows are red and I need them blank, until data is entered into columns K and L. Hope that makes sense.
Bookmarks