Conditional Formatting for Quarters Based on a specific date

[aasher1]

I have fields that have a formula that enters a month and year, for 13 months, based on the date in a cell A5. This month and year changes based on the date entered. Could be January, could be November, but I need the cell to fill with a particular color based on the month/quarter in which it falls. See Below.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]Quarter Based on
date in cell A5
[/TD]
[TD]Date in these cells
change based on
formula result in
cell B14:N14
(See Table at bottom)
[/TD]
[/TR]
[TR]
[TD]YELLOW/Q1
[/TD]
[TD]Jan-Mar
[/TD]
[TD]Apr-Jun
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Apr-Jun
[/TD]
[TD]Jul-Sep
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jul-Sep
[/TD]
[TD]Oct-Dec
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Oct-Dec
[/TD]
[TD]Jan-Mar*
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ORANGE/Q2
[/TD]
[TD]Jan-Mar
[/TD]
[TD]Jul-Sep
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Apr-Jun
[/TD]
[TD]Oct-Dec
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jul-Sep
[/TD]
[TD]Jan-Mar
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Oct-Dec
[/TD]
[TD]Apr-Jun*
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RED/Q3
[/TD]
[TD]Jan-Mar
[/TD]
[TD]Oct-Dec
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Apr-Jun
[/TD]
[TD]Jan-Mar
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jul-Sep
[/TD]
[TD]Apr-Jun
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Oct-Dec
[/TD]
[TD]Jul-Sept*
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BLUE/Q4
[/TD]
[TD]Jan-Mar
[/TD]
[TD]Jan-Mar
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Apr-Jun
[/TD]
[TD]Apr-Jun
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Jul-Sep
[/TD]
[TD]Jul-Sep
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Oct-Dec
[/TD]
[TD]Oct-Dec*
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cell A5 Date =
[/TD]
[TD]06/25/18
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


* Will be the following year.

I know this is stretch or it's much easier then I'm making it.

You're help is greatly appreciated.


[TABLE="class: grid, width: 700"]
<tbody>[TR]
[TD]Contacts
Month/Year
[/TD]
[TD]Jul / 18
[/TD]
[TD]Aug / 18
[/TD]
[TD]Sep / 18
[/TD]
[TD]Oct / 18
[/TD]
[TD]Nov / 18
[/TD]
[TD]Dec / 18
[/TD]
[TD]Jan / 19
[/TD]
[TD]Feb / 19
[/TD]
[TD]Mar / 19
[/TD]
[TD]Apr / 19
[/TD]
[TD]May / 19
[/TD]
[TD]Jun / 19
[/TD]
[TD]Jul / 19
[/TD]
[/TR]
</tbody>[/TABLE]

 

[aasher1]

I forgot to add that the months for the quarter in which the date in cell A5 falls does not get a color. If date in A5 = 1/25/18, the first month will be Feb/18. Feb/18 and Mar/18 will not have a color.

Thank you.

 

[aasher1]

Thank You, but this has been solved on another Excel Forum.