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!