Excel formula for dates with variable

Help!!! I need help with a conditional formatting formula that will:

Column G is all dates

For all of column G, if date is today plus no more than 7 days then, I choose a color:

+

For all of column G, if date is today and more than 8 days but no more than 14 days, then I choose another color:

+

For all of column G, if date is today and more than 15 days, then I choose a 3rd color

Select column-G then conditional formatting > New Rule

Then like this for the first condition. Add 2 more rules similarly for your other criteria.

CF_time.png


Let me know if you need more detail.

GeoffW283 My options don't look like that. Apparently "I am not allowed to post any kinds of links, images or videos until you post a few times." Do you have an email I can use to send you a couple images?

Posting links will be a problem until you have made a few posts but you should be able to post images - give it another try.

I'm not familiar with the Mac version of Excel - maybe the user interface is a little different. Can you get to the conditional formula area at all? If so then you are looking for what is one of the most basic options whereby the conditional formatting of a cell is based solely on the value of that cell.