if in conditional formatting
 

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?


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=558892

if in conditional formatting
 

DKY,

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

=MONTH(TODAY())=7

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=558892

if in conditional formatting
 

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

=Month(Today())=7 would suffice


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=558892

if in conditional formatting
 

Just use...

=MONTH(NOW())=7


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=558892

if in conditional formatting
 

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


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=558892

if in conditional formatting
 

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

"SteveG" wrote:


DKY,

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

=MONTH(TODAY())=7

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=558892

if in conditional formatting
 

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

Nolene wrote:

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

"SteveG" wrote:


DKY,

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

=MONTH(TODAY())=7

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=558892



--

Dave Peterson