You can't generate different formats from one conditional formatting
condition, you'll need at least as many conditions as formats so

=M68

format as red bold italic

=M65

format as green bold italic

What other conditions do you have?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=527882