View Single Post
  #3   Report Post  
Old February 1st 05, 10:40 AM
Bob Phillips
 
Posts: n/a
Default

If you need more than 3 conditions, check out
http://xldynamic.com/xld.CFPlus.Dowmload.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Max" wrote in message
...
Perhaps you could paste a sample of all the CF formulas (for Conditions 1

to
3) used currently for a particular cell ? Think it would make it much

easier
for clarity, and for help to arrive

--
Rgds
Max
xl 97
---
GMT+8, 1 22' N 103 45' E
xdemechanik <atyahoo<dotcom
----

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