Conflicting Conditional Formatting

[Guest]

I am having trouble with conflicting conditional formatting. I have a list
that I need to have highlighted in one of three colors based on the result of
the formula in column D, and I need to have the text adjusted according to
the result in column G. I have tried having the text formatting as condition
one and shading as condition one, in either case, only the first condition is
applied. (Although the cells that meet only one of the conditions format
properly.)

Here are my conditions:
Condition 1: Formula is =$D23>40 (Shading)
Condition 2: Formula is =$D23>25 (Shading)
Condition 3: Formula is =$D23=1 (Text formatting)

I though of using an AND function, but had trouble getting it to work and I
have 6 potential states and the limit of three will not cover them:
No shade, normal text
No shade, grey ital text
Shade 1, normal text
Shade 1, grey ital text
Shade 2, normal text
Shade 2, grey ital text

Thanks for any help you can offer

 

[Dave Peterson]

As soon as one condition is true, then that formatting takes place. The other
rules are ignored.

So I don't think Format|Conditional formatting will work for you with those 6
rules.

You may be able to use an event macro to actually shade rows and apply different
formatting, though.