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?

 

[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

 

[Guest]

How would I do this if I wanted to highlight every cell that has 12/31 (Dec
31) for any year in it?

 

[Dave Peterson]

=text(a1,"mm/dd")="12/31"

How would I do this if I wanted to highlight every cell that has 12/31 (Dec
31) for any year in it?