| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format Based on Date | Excel Worksheet Functions | |||
| Conditional Format based on date | Excel Worksheet Functions | |||
| Conditional Format for a date 1 month before Expiration in Excel 2 | Excel Worksheet Functions | |||
| how do you conditional format based upon today's date? | Excel Worksheet Functions | |||
| Conditional Format based on date ranges | Excel Worksheet Functions | |||
Threaded Mode
