Conditional Formatting

[baz]

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

 

[David Biddulph]

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%.