Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for CF to color current month
My extense worksheet of DATES need to color RED the cell that has the date of
the current month( ex.. 9/2/8, 9/10/8, 930/8 ), and will change accordinly to each month. I guess using a formula in conditional formatting, but I have not been able to figure it out after trying diferent formulas. Open for formulas. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for CF to color current month
Select your range to format
I selected A:E and with A1 the activecell: Formula is: =text(a1,"yyyymm")=text(today(),"yyyymm") This checks both year and month. If you only cared about the month: Formula is: =month(a1)=month(today()) computexcel wrote: My extense worksheet of DATES need to color RED the cell that has the date of the current month( ex.. 9/2/8, 9/10/8, 930/8 ), and will change accordinly to each month. I guess using a formula in conditional formatting, but I have not been able to figure it out after trying diferent formulas. Open for formulas. Thanks. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for CF to color current month
Thanks Dave, Wonderformula!
"Dave Peterson" wrote: Select your range to format I selected A:E and with A1 the activecell: Formula is: =text(a1,"yyyymm")=text(today(),"yyyymm") This checks both year and month. If you only cared about the month: Formula is: =month(a1)=month(today()) computexcel wrote: My extense worksheet of DATES need to color RED the cell that has the date of the current month( ex.. 9/2/8, 9/10/8, 930/8 ), and will change accordinly to each month. I guess using a formula in conditional formatting, but I have not been able to figure it out after trying diferent formulas. Open for formulas. Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Chg Tab Color vs Current Month | Excel Discussion (Misc queries) | |||
Current date formula based on month | Excel Discussion (Misc queries) | |||
how to adjust formula dependent on current month | Excel Discussion (Misc queries) | |||
Change Cell Color if in current Month | Excel Worksheet Functions | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) |