why doesn't condition 1 work

T

terry

I have a report that I want to do conditional formatting. I set up the
conditional formatting like this
Cond 1 - field value is greater than [other field] make the text Red
Cond 2 - field value is less than [other field] make the text Dark Yellow

set up like this condition 2 works and fields that are less than the other
value text is yellow. Condition 1 doesn't work at all.

Cond 1 - field value is less than [other field] make the text Dark Yellow
Cond 2 - field value is greater than [other field] make the text Red

Set up like this condition works and fields that are greater than the other
value text is red.

I can't get both conditions to work like this. So I tried this...
Cond 1 - field value is greater than [other field] make the text Red
Cond 2 - field value is greater than [other field] make the text Red
Cond 3 - field value is less than [other field] make the text Dark Yellow

This does what I want, but I shouldn't have to do it like this. Why is this
happening?
 
Top