I am trying to track dates on my spredsheet but am having great difficulty figuring out the formatting for the date ranges. I need:
all dates before today = black fill/white font
today-next 3 months = red fill/yellow font
next 4 months-next 6 months = yellow fill/black font
next 7 months + = no fill/black font
I am using Excel 2007, and I have very little excel experience so please dumb down the answer. Thanks for any help you all can offer!
Bookmarks