Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conflicting Conditional Formatting
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 =$D2340 (Shading) Condition 2: Formula is =$D2325 (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 -- L |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conflicting Conditional Formatting
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. LMcK wrote: 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 =$D2340 (Shading) Condition 2: Formula is =$D2325 (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 -- L -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |