| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional Format (month and year) = Today()
I have a calendar in excel that I want to change the format of the header for
each month, when that month is the current month. Right now my conditional format formula is =Q31=MONTH(TODAY()) The problem is that as long as I am in (for example) November of any year the condition reads true. It does not distinguish between 11/2005, 11/2006, 11/2007. I'm stuck at this point... thinking the conditional format formula should look like: =q31=AND(MONTH(TODAY()),YEAR(TODAY())) But that's not working. Can you help? Thanks in advance. Scott |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| month & year format in two digits | Excel Discussion (Misc queries) | |||
| sort dates by day then month, not by year. | Excel Worksheet Functions | |||
| HELP - need to returns the current number of past month this year and ... | Excel Worksheet Functions | |||
| Month Year Date Format | Excel Worksheet Functions | |||
| Insert Month and Year in my worksheet | Excel Worksheet Functions | |||
Threaded Mode
