Conditional Formatting based on Month

[KranerRyan]

I have a list of data from Jan 2014 - Dec 2018. Is there an easy way to use conditional formatting so all the Jan,Mar,May,Jul,Sep,Nov are filled Gray while Feb,Apr,Jun,Aug,Oct,Dec are Blue?

Thanks!

 

[jtakw]

Hi,

2 CF rules, one for Gray, one for Blue.

CF, use formula,

Book1
	A	B	C
1		For Gray	For Blue
2	Jan-14	TRUE	FALSE
3	Feb-14	FALSE	TRUE
4	Mar-14	TRUE	FALSE
5	Apr-14	FALSE	TRUE
6	May-14	TRUE	FALSE
7	Jun-14	FALSE	TRUE
8	Jul-14	TRUE	FALSE
9	Aug-14	FALSE	TRUE
10	Sep-14	TRUE	FALSE
11	Oct-14	FALSE	TRUE
12	Nov-14	TRUE	FALSE
13	Dec-14	FALSE	TRUE
Sheet417

Cell Formulas
Range	Formula
B2	=ISODD(MONTH(A2))
C2	=ISEVEN(MONTH(A2))