Conditional Formatting based on between dates and a word in another cell

Interlocal and Services.JPG

What I want to do is have Conditional Formatting look to see if the Ending(B2) date is 90 days from now and if the Type(C2) is Interlocal, if so highlight the cell. I want Conditional Formatting to look to see if the Ending(B2) date is 180 days from and if the Type(C2) is Services, highlight the cell. Then I want it to shut off after Today has passed.

I can change the highlighting of the date on and off based on if it is 90 days from now and if today has past, but then that doesn't give me if it is Interlocal or Services. I used Conditional Formatting Cell Value between =TODAY()+90 AND =TODAY() to turn on the start of the 90 days and turn off after today has passed. It worked in the date field, but nothing is working if I have it in the Type field and use other formulas.

Past this I am lost.

Any help would be great, I am new to this posting.
Thank you

Perhaps use a formula in your CF rather than Between.

Formula:

Please Login or Register  to view this content.

If that doesn't do what you need then attach a sample workbook with your expected results manually highlighted.

BSB

Interlocal and Services.JPG
Thank you for all your help, I can't find a way to upload a worksheet in a reply and it wasn't working earlier?
I have attached a picture of what it should look like when finished, based on Interlocal is 90 days and Services is 180.
I can't get it to work with either formula?
I had this one working for 90 days, but it wouldn't base it on the type and didn't shut off after todays date, but I messed it up somewhere along the line?
=AND(ISNUMBER(H1),H1>TODAY()+90)

Sorry I cleaned up the data to simplify it. H1=B1
I think my last post will clarify.

FDibbins I did just consider that but it still is not picking the right dates and the color is overlapping? I did notice that I said yellow in one sheet and have it green in another.
So I am not getting why when
I want Services to go from today to today + 180days and turn yellow, it is picking from 10/05/18- 03/05/19 and picking green
=AND($B2>=TODAY(),$B2>=TODAY()+180,$C2="Services")

I want Interlocal to go from today to today + 90days and turn green, it is picking from 11/05/18 -02/05/19 and picking yellow.

=AND($B2>=TODAY(),$B2>=TODAY()+90,$C2="Interlocal")

And there is overlapping of the color on two of them?

Is this a calendar thing?

Thank You FDibbins
As you can see from my attachment(Book1) it still is not working?

I attached a version of what my data looks like and it seams to pick random items to highlight?(Book4)

I don't know what to do other than run the conditional formatting off of Column B, then make them sort manually by "Interlocal" and "Services"?

Thanks for all your help I have been trying to get this to work most the day and it is not working no matter what I do?