Conditional Formatting: Formula is
 

I need a formula where D6 font colour will respond to M6 on the following
criteria:
if M6 is 5 and < 9 then font to change to green bold italic
if M6 is 8 then font to change to red bold italic
otherwise font to be black
(D6 is text and M6 is numerical)
Needs to be a nested formula as I have other conditional formatting
conditions already applied to the cell. Running excel 2003
Can anyone please help?

Conditional Formatting: Formula is
 

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

Conditional Formatting: Formula is
 

Hi daddlonglegs,
I have for cell D6
=L60 then the name is crossed out
and
=P621 then the name is changed to blue
as well as the ones I would like to add.
Can it not be nested using ; ?


"daddylonglegs" wrote:


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