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?