View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
baz baz is offline
external usenet poster
 
Posts: 2
Default Conditional Formatting

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