I seem to be having quite the conundrum and after hours of searching cannot find the answer. Hoping someone with some more experience can help me.

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 -- =$F166TODAY()+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 isn't anything in the cell to begin with.

I know I am most likely missing something obvious, but I can't figure out what it is.

Thank you so much for your time!