Multiple Conditional Formatting Rules Based on Today’s Date

[claybwagner28]

I feel embarrassed to ask this question but I have searched for a solution and can’t find the solution.

I have several dates in Column H. I want to format cells that have dates than are 365 days or older Red.
I want similar formats for cells that are between 365 days and 180 days Orange
I want similar formats for cells that are between 180 days and 90 days Yellow
Finally I want to format for cells that are within 90 days Green

What formulas should I use?
Thanks in advance!
Clay

 

[Joe4]

365 days or older would look something like:

=TODAY()-H2>=365

Between 180 and 365 would look something like:

=AND(TODAY-H2<365,TODAY-H2>=180)

And rest should pretty much follow these patterns.

 

[claybwagner28]

Thanks!

 

[Joe4]

You are welcome.