if in conditional formatting

[DKY]

I'm trying to do conidtional formatting and I want the cell to turn a color if the month is july. So, I set it to 'Formula is' and put this
=IF (MONTH(TODAY()))=7
but it doesn't work. Help?

[SteveG]

DKY,

You don't actually need the IF in your statement. Just use,

=MONTH(TODAY())=7

HTH

Steve

[Vito]

Don't use the IF part, it is implied in Conditional Formatting

=Month(Today())=7 would suffice

[ChrisMattock]

Just use...

=MONTH(NOW())=7

[ChrisMattock]

OK so I only get the Bronze medal but mine uses two less letters :P