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)