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 |
#2
|
|||
|
|||
Conditional Format (month and year) = Today()
Try, as the cond format formula:
=DATE(YEAR(Q31),MONTH(Q31),1)=DATE(YEAR(TODAY()),M ONTH(TODAY()),1) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Scott" wrote in message ... 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 |
#3
|
|||
|
|||
Conditional Format (month and year) = Today()
Worked like a charm.
Thanks! "Max" wrote: Try, as the cond format formula: =DATE(YEAR(Q31),MONTH(Q31),1)=DATE(YEAR(TODAY()),M ONTH(TODAY()),1) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Scott" wrote in message ... 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 |
#4
|
|||
|
|||
Conditional Format (month and year) = Today()
Glad to hear that !
Thanks for the feedback .. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Scott" wrote in message ... Worked like a charm. Thanks! |
Reply |
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 |