Conditional Formatting: Formula is

[Sue]

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?

 

[daddylonglegs]

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

=M6>8

format as red bold italic

=M6>5

format as green bold italic

What other conditions do you have?

 

[Sue]

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