Traffic light help needed

[wmedjaxnjr]

So, I am trying to use the traffic lights to help with something I am working on in Excel. What I need is the following:

Based on the date in A1 (for example), I need the :


green traffic light if 30 days out from today (the current date)
yellow traffic light if between 15 and 29 days out from today (the current date)
red traffic light if between 1 and 15 days out from today (the current date)
black traffic light if greater than 30 days out from today (the current date)

So, if today is 4/5/2016 and the date in column A1 is 30 days from today the stop light should be green. Likewise, if the date in column A1 is 31 and greater days from today, the stop light should be black and so on for the rest.

Anybody out there who can help me figure this out?

[OfficeNewb]

Hello -

The conditional format should look something like this...