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

[Erkden]

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

[FDibbins]

Hi and welcome to the forum

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you