Conditional Formatting based on dates, Formula to add the outcomes as they change

Hi dear
You mean you need four conditions in each cell for the whole sheet or might be 200 cells suppose.
here is the formula:

1:-=$H2<=TODAY() ,
2:-=$H2<=TODAY()+30,
3:-=$H2<=TODAY()+60

you can add forth condition as per your requirement for example =$H2<=TODAY()+90
H2 is column+row

few things to remember

Just remember always check the box "stops if true" and second thing to be in mind is ,keep in order from the arrow after the button "delete rule". you should keep formulas in the order like i have given above in ascending order,if you will not do so then excel will just take the upper condition ,will not take all the conditions

hope helpful

I’ve attached a sample of what I am trying to create.
The outcome that I’m trying to reach is that a static date goes under each column (D-H in this case). This date is based on an actual completion, and expected to change only when a completion certificate is submitted.
To give my Soldiers the best knowledge, as far as a quarter out for yearly, and 9 months out for 4 year requirements, I would like to have this tool color code. (Soldiers love colors, but hate when there is red or black by their name.)
So, for columns that are yearly requirements, I would like the selected range (2-7 in this case) in each column to color code off of expiration time and 30 days at a time.
1 year requirements – Green/90-61 days , Yellow/60-31 days, Red/30-1 days, Black past expiration
4 year requirements – Green/270-181 days , Yellow/180-91 days, Red/90-1 days, Black past expiration
My end goal is to keep this as a running spreadsheet that only requires updating anyone’s date submission once a month and it works for both myself, and the guy that follows me, instead of re-inventing the wheel each time someone rotates out. And it beats flipping through a binder of 100’s of names every month! 
If someone adjusts this to put in what I am looking for, I only ask that I am told what was changed, and why the method was chosen so that I can build a foundation to expand this example into use and further use the program to give time and initiative back to the guy on the bottom. So, while this will make it easier for me to track items, I can let them know quite some time out when they are due, and it’s not a surprise when time is constrained later.
Thanks in advance, and for the tips I’ve received already. I’m a little behind the power curve on yours FDibbins, or running a different version of excel. I’m not sure what I misinterpreted from your instructions, but I couldn’t get the cells to format with the dates that I’ve put in the attachment which are purposely derived to get the colors to pop up (even the ones within the good date range were going red.) I deleted the rules out to not confuse myself, or someone else that may try and touch it up.
Imranorakzai- I had the same problems with yours, but maybe it’s because of the +30 instead of minus since the dates are all past and should be growing closer to? I’m too new to this to play doctor on what I did wrong or make possibly incorrect assumptions when I just misunderstood and inserted it correctly.
Either way, thank you both for the input!

imranorakzai, I finally got your attachment to download after I submitted my last reply. I think it cleared up some of my questions and you and I are tracking really close to the same page. I may have it turned around in my head, but since your sheet is set up with a specific column denoting "Expiration," I may just be making it too hard in my head....since everyone has been telling me that I would need to take today and subtract the days out that I wanted for a warning somewhere in the formula. I'm still not sure how you input those into the conditional formatting. When I go to create a new rule, it gives me a number of selections to chose from on how I would like to implement the rules first, and I may be choosing the wrong one there.

FDibbons - That may be why yours are not working either. I'm seeing a lot of options for how to apply the formula before I ever get the chance to input the formula itself. I'm guessing at which ones I chose, and possibly coming out with the wrong one.

hi jax
sorry i didnt get what you are indeed asking.can you clear please in how many columns you need the conditions .highlight the column also.because they have some confused dates

Originally Posted by imranorakzai

hi jax
sorry i didnt get what you are indeed asking.can you clear please in how many columns you need the conditions .highlight the column also.because they have some confused dates

imranorakzai,
The formatting will apply to all columns, and eventually many more. I just wanted to give an example of the spreadsheet as suggested. Each of the dates currently put in are fictitious, and we're meant to either fall within the "good" range where they don't change color, or each one of the color phases, based on today's date.
This isn't the sheet that they will end up going into (personal information and such are in the one that I'm finishing on my work computer). That's also one of the reasons that I'm asking for an example of what and how the input is done. It would allow me to learn how the function works, and apply it to the one on my work computer. I'm on my phone at the moment, so I can't complete the highlight request for you. Please excuse me on that. I hope that I've answered your question?

Imranorakzai,
I think that the difference between what I’m looking for, and your example is that your sheets show the expected expiration date. Due to the way that I’m inspected and present information, I have to give the last completion date (We’re dealing with the WHY generation here….If I can show the WHY is because of date of last completion, I’m not wasting their time, or mine. ) I also cut my attachment down to two columns of information to eliminate confusion.

Presentation is everything, and I’m trying to best cater to my receiving audience. Thank you!