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.

	Quarter Based on date in cell A5	Date in these cells change based on formula result in cell B14:N14 (See Table at bottom)
YELLOW/Q1	Jan-Mar	Apr-Jun
	Apr-Jun	Jul-Sep
	Jul-Sep	Oct-Dec
	Oct-Dec	Jan-Mar*
ORANGE/Q2	Jan-Mar	Jul-Sep
	Apr-Jun	Oct-Dec
	Jul-Sep	Jan-Mar
	Oct-Dec	Apr-Jun*
RED/Q3	Jan-Mar	Oct-Dec
	Apr-Jun	Jan-Mar
	Jul-Sep	Apr-Jun
	Oct-Dec	Jul-Sept*
BLUE/Q4	Jan-Mar	Jan-Mar
	Apr-Jun	Apr-Jun
	Jul-Sep	Jul-Sep
	Oct-Dec	Oct-Dec*
Cell A5 Date =	06/25/18

<tbody>
</tbody>

* 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.

Contacts Month/Year

Jul / 18

Aug / 18

Sep / 18

Oct / 18

Nov / 18

Dec / 18

Jan / 19

Feb / 19

Mar / 19

Apr / 19

May / 19

Jun / 19

Jul / 19

<tbody>
</tbody>

 

[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.