I seem to be having quite the conundrum and after hours of searching
cannot find the answer. Hoping someone with some more experience can
Right now I have a sheet with dates in column "E". I am trying to make
it so that when a date is entered into that column it turns green if it
is 181+ days from todays date, yellow if it is from today until 180 days
and this is where the issue exists, red when the date is expired.
Problem is I am using Excel 2003 and can only use three conditional
formatting rules so they are as follows:
Green --> =$F166>TODAY()+181
Red --> =$F166<TODAY()
Yellow --> =TODAY()-$F166<180
I am trying to make it so the date does not change to 0/Jan/1900 and
turn red if there is not anything in the cell to begin with.
I know I am most likely missing something obvious, but I cannot figure
out what it is.
Thank you so much for your time!