Conditional Format based on Month of Date in Cell

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I have a cell that I typed in 1/1/2010 and I want to conditional format it
based on what month it is. Say format blue text if it's 1/1/2010 and green
text if 2/1/2010.

I did a test with formula =IF(MONTH(A1)=1,"yep","nope") and it returns "yep"

So I tried to use the following in the conditional formatting window based
on formula:
MONTH(A1)=1 which does nothing.

The formula =MONTH(A1) returns a value of 1 so I don't see what the problem
is.
 
Hi

Using formulas in conditional formatting, the equtation must always start
with an equal sign:

=Month(A1)=1

Regards,
Per
 
Back
Top