| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting dates
i want to match the month in a series of dates, structured like this -
05/12/2008 any ideas? thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting dates
05/12/2008
Is that May 12 2008 or December 5 2008? If you want to conditionally format the cells based on the month: Assume you have a range of dates in A1:A10 In Excel versions 2003 and earlier Select the range of cells A1:A10 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =MONTH(A1)=n Where n = the month number of interest: January =1 through December =12 Click the Format button Select the desired style(s) OK out In Excel 2007 Select the range of cells A1:A10 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =MONTH(A1)=n Where n = the month number of interest: January =1 through December =12 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "yuen" wrote in message ... i want to match the month in a series of dates, structured like this - 05/12/2008 any ideas? thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting dates
im setting the date to uk format so 5th December 2008 and want to compare it to today's date. how do i do that? "T. Valko" wrote: 05/12/2008 Is that May 12 2008 or December 5 2008? If you want to conditionally format the cells based on the month: Assume you have a range of dates in A1:A10 In Excel versions 2003 and earlier Select the range of cells A1:A10 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =MONTH(A1)=n Where n = the month number of interest: January =1 through December =12 Click the Format button Select the desired style(s) OK out In Excel 2007 Select the range of cells A1:A10 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =MONTH(A1)=n Where n = the month number of interest: January =1 through December =12 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "yuen" wrote in message ... i want to match the month in a series of dates, structured like this - 05/12/2008 any ideas? thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting dates
Ok, if it's for conditional formatting just change the formula to:
=MONTH(A1)=MONTH(NOW()) -- Biff Microsoft Excel MVP "yuen" wrote in message ... im setting the date to uk format so 5th December 2008 and want to compare it to today's date. how do i do that? "T. Valko" wrote: 05/12/2008 Is that May 12 2008 or December 5 2008? If you want to conditionally format the cells based on the month: Assume you have a range of dates in A1:A10 In Excel versions 2003 and earlier Select the range of cells A1:A10 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =MONTH(A1)=n Where n = the month number of interest: January =1 through December =12 Click the Format button Select the desired style(s) OK out In Excel 2007 Select the range of cells A1:A10 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =MONTH(A1)=n Where n = the month number of interest: January =1 through December =12 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "yuen" wrote in message ... i want to match the month in a series of dates, structured like this - 05/12/2008 any ideas? thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting dates
im hi-lighting cells i want to compare and clicking on condtional formatting
tab then new rule and entering the formula you have given with a1 as the date of today e.g. b2 which has =today() but nothing is happening? "T. Valko" wrote: Ok, if it's for conditional formatting just change the formula to: =MONTH(A1)=MONTH(NOW()) -- Biff Microsoft Excel MVP "yuen" wrote in message ... im setting the date to uk format so 5th December 2008 and want to compare it to today's date. how do i do that? "T. Valko" wrote: 05/12/2008 Is that May 12 2008 or December 5 2008? If you want to conditionally format the cells based on the month: Assume you have a range of dates in A1:A10 In Excel versions 2003 and earlier Select the range of cells A1:A10 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =MONTH(A1)=n Where n = the month number of interest: January =1 through December =12 Click the Format button Select the desired style(s) OK out In Excel 2007 Select the range of cells A1:A10 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =MONTH(A1)=n Where n = the month number of interest: January =1 through December =12 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "yuen" wrote in message ... i want to match the month in a series of dates, structured like this - 05/12/2008 any ideas? thanks! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting dates
What version of Excel are you using?
Tell me *exactly* what cells you want to apply the conditional formatting to. -- Biff Microsoft Excel MVP "yuen" wrote in message ... im hi-lighting cells i want to compare and clicking on condtional formatting tab then new rule and entering the formula you have given with a1 as the date of today e.g. b2 which has =today() but nothing is happening? "T. Valko" wrote: Ok, if it's for conditional formatting just change the formula to: =MONTH(A1)=MONTH(NOW()) -- Biff Microsoft Excel MVP "yuen" wrote in message ... im setting the date to uk format so 5th December 2008 and want to compare it to today's date. how do i do that? "T. Valko" wrote: 05/12/2008 Is that May 12 2008 or December 5 2008? If you want to conditionally format the cells based on the month: Assume you have a range of dates in A1:A10 In Excel versions 2003 and earlier Select the range of cells A1:A10 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =MONTH(A1)=n Where n = the month number of interest: January =1 through December =12 Click the Format button Select the desired style(s) OK out In Excel 2007 Select the range of cells A1:A10 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =MONTH(A1)=n Where n = the month number of interest: January =1 through December =12 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "yuen" wrote in message ... i want to match the month in a series of dates, structured like this - 05/12/2008 any ideas? thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Dates | Excel Discussion (Misc queries) | |||
| Conditional formatting - Dates | Excel Discussion (Misc queries) | |||
| Conditional formatting dates | Excel Discussion (Misc queries) | |||
| Dates in Conditional Formatting help!!! | Excel Worksheet Functions | |||
| Conditional Formatting with Dates | Excel Worksheet Functions | |||
Hybrid Mode
