View Single Post
  #1   Report Post  
Old February 1st 05, 08:09 AM
Geremia Doan
Posts: n/a
Default Banding with Conditional Formatting with Multiple Conditions

I can set up banding using Conditional Formatting fust fine. The problem I
am having is that there are other conditions I need to have happen at the
same time. For example, when cell F69 is greater than cell D72, I need it to
be BOLD and ITALICIZED. When I use the banding formula in Conditional
Formatting as the first Condition, it overrides the other conditions, so the
cell is shaded, but not BOLD and ITALICIZED. If I make it the last
Condition, the BOLD and ITALICIZED condition overrides the banding Condition.
Does anyone know if there is a way to get around this problem? A lengthy
formula, perhaps, to put into Conditional Formatting that will perform both