View Single Post
  #4   Report Post  
Old February 1st 05, 03:44 PM
JulieD
 
Posts: n/a
Default

Hi Geremia

not sure what you want Bold & Italicized - all the "banded" rows or row #69.

--so all odd rows banded, bold & italicized when f69D72
1st condition
=AND(MOD(ROW()-1,2)+1<=1,$F$69$D$72)
-set formatting for banding colour & font bold & italicized

2nd condition
=MOD(ROW()-1,2)+1<=1

--only row 69 bold & italicized
1st condition
=AND(MOD(ROW()-1,2)+1<=1,$F$69$D$72,ROW()=69)
-set formatting for banding colour & font bold & italicized

2nd condition
- as above

Hope this helps
Cheers
JulieD

"Geremia Doan" wrote:

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
functions?