[Solved] Color coordinate

[BrianDP1977]

Okay, I’m stuck:

I need to color code a date header that changes over time. If the month listed in the header is DEC – FEB, I need the font to be red. If it is MAR – MAY, the font should be GRN. If it’s JUN – AUG, it should be BLUE. If it’s SEP – NOV it needs to be black. Since I really only need three conditions to color code everything except the last three months (which can remain the automatic black) I figure I can use conditional formatting for the cells. However, the problem that I’m running into is the first DEC – FEB which equates to defining a month range between or equal to 12 – 2 which I cannot make work. Please help.

 

[Pekkavee]

You can use OR in CF in "Formula is"-box

=OR(MONTH(A1)=1,MONTH(A1)=2,MONTH(A1)=12)

Pekka

 

[BrianDP1977]

That did the trick. Thank you very much.