[Solved] Color coordinate

BrianDP1977

Board Regular
Joined
Nov 5, 2005
Messages
146
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.
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Pekkavee

Well-known Member
Joined
May 25, 2004
Messages
1,218
You can use OR in CF in "Formula is"-box

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

Pekka
:eek: :eek:
 

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,505
Members
412,671
Latest member
vitaminshop20
Top