I'm having a bad brain day and I just can't figure this out, lol.
I have two columns in a table, F and G, that contain dates (in date format). I want to use conditional formatting such that when I open the workbook, Excel compares the dates in both columns to today's date (TODAY()? NOW()?) and if the date is in the past, format the cell red, if it's within 90 days, format the cell yellow, and if the date is over 90 days in the future, format the cell green. Can you help, or at least pointing me in the right direction?
Thanks so much.
I tried ="datedif($F$3, today()) < 90" and =DATEDIF($F$3, TODAY(),"m")<3 where F3 is the first column/row that contains a date, and applied it to the range $F$3:$G$118 (last column/row with a date. It didn't do anything, lol.