If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Format based on Month of Date in Cell
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. |
#2
|
|||
|
|||
Conditional Format based on Month of Date in Cell
Hi
Using formulas in conditional formatting, the equtation must always start with an equal sign: =Month(A1)=1 Regards, Per "Joe" skrev i meddelelsen ... 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. |
Thread Tools | |
Display Modes | |
|
|