Conditionally format a range of dates

[Mr_Phil]

Hello, I am stuck on what sounds like a simple thing but is kicking my tail.
We do projects based on a simple range of dates.
I need to conditionally format that range. I can do each cell using today() and <=> operators but then I get some cells that are green and yellow. It wouldn't be bad if it were a gradient where in mid project we were mostly green or something. But essentially what I pasted would be just fine. But it just isn't coming together for me. Any advice, tutorial, video, anything at all? Thanks for reading. I do appreciate the time people spend here just helping out.

 

[Joe4]

Try these rules:

Proof:

 

[Mr_Phil]

Try these rules:

View attachment 115838
Proof:

View attachment 115839

Reading it I can see exactly why it works. And it works. I do appreciate your help very much.
Now the mystery is why I didn't see it for myself when I was mixing and matching various formulas that worked a bit here and a bit there but didn't tie it.
Thank you again.
#SolutionVerified

 

[Joe4]

You are welcome.
Glad I was able to help!