Conditional Formatting
What condition are you using?
If the number in the cell is 201%, your test needs to be 200% or 2, not
200. If your condition asks for 200, it won't be triggered until your
value reachs 20000%.
--
David Biddulph
"baz" wrote in message
...
Please POST response because email used is bogus to prevent spam:
In my cells I have a formula and the formatted result in a percentage
format.
In my conditional formatting I have one condition if the cell value is
less that 0 (zero) a certain pattern color and font format. This works
just fine.
My second condition is where I am having problems - I say if cell
value is GREATER that 200 another pattern color and text color.
The first condition work great but not the secong.
I'd appreciate ANY insight and thatnks in advance.
baz
|