Change Cell color based on different cell value and three date ranges

Hi all,

Thanks for your help with this little problem of mine.

I want to change a series of cell colors based on the date at the top of the column.

If the number above falls within any of the three ranges then I want the corresponding cell to change colors appropriately.

In this scenario, the date ranges are what changes, not the date above.

I've attached a screen shot, hopefully that gives some visual reference. I've manually filled in the colors for reference.

Thanks in advance!

Cheers,
Erik