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!