Conditional Formatting to color one cell based on a month from a date in another cell

This is similar to a previous post that showed for a date range. I need by a month range.

I need it to look at a field (A5) and if the date is between January and March to make the cell one color, if the date is between April and June to be a different color. I did similar to what you did above and it accepts it, but doesn't color the cell.

=AND($A$5>=MONTH(1), $A$5<=MONTH(3))

I also have fields that have a formula that enters a month and year based on a date in a cell. This month and year changes based on the date. 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 fills with. Used the same formula as above.

You're help is greatly appreciated.

A5 is the cell I need the formulas to look at. Cell A5 is the date we Exit a client and it's the date I need to use to determine what Quarters need to be highlighted. The 1st quarter after exit is Yellow, 2nd is orange, 3rd is red, and 4th is blue.

I know what I'm asking for is a stretch and more then likely impossible. I attached a sample of each quarter to show how I need the coloring to be based on the date in cell A5.

Ok. I managed to get part of what I want to work. See attached. The center section works the way I want. Colors for each section change how I need it to based on the date in A5. But now the lower section (Contact Mon/Year) is not working correctly for each quarter. The highlight colors for the lower section need to match the highlighted colors in the middle section. It's right for the Quarter of January 01 - March 31, the rest are off. See Samples in previous message.

Oh Wow! Thank you! That's perfect! I would never have thought of doing it that way. This saves us sooo much work of having to manually change the colors everytime we create this form for each client (several hundred a year).