I have a conditional format problem

[Jon123]

I'm trying to use setup if the field value is within + or - 0.1
so in the conditional format I have field value is Between (([dat100])-(0.01)) and (([dat100])+(0.01))

Then I have the came this for field value Not Between. The not between turns the field RED the Between should be Blue but no matter what I alway get RED.

Jon

 

[RichP]

I'm not completely sure what you are trying to do but it sounds as though you have a field called dat100 and you would like it to be red if the value is between -0.1 and 0.1. If that is correct then you need to set the conditional format to
'field value is' 'between' '-0.1 and 0.1'
where each of the items between quotes is one of the boxes in the rule for the conditional format for that field. You of course need to set that if the rule is true the text goes red

If you want another field to go red if dat100 is between -0.1 and 0.1 then you need to set

'Expression is' '[dat100] Between -0.1 And 0.1' for the two boxes available for the rule

Apologies if I misunderstood what you are trying to do

 

[Jon123]

Yes I was over thinking it. thank you that helped

jon