What are your CF conditions, and in what order?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Conditional Formats" <Conditional wrote
in message ...
I'm having an issue getting my condtional format to read negative numbers.
The format is if the reference cell is less then 100 fill the box red. The
reference cell is a lookup value. The conditional format works for
everything
including zero but once you hit -1 it goes back to green (a different
conditional format for 100)