absolute value in conditional formatting

[dballard]

I would like to use conditional formatting on a field if the absolute value
of the field exceeds a certain amount. I am having difficulty with getting
the expression correct in the conditional formatting dialog.

 

[Wayne-I-M]

What is the value ?

 

[dballard]

The field being compared has values ranging from -20 to +20 and the
comparison I would like to make is if the field is greater than an absolute
value of 10.

 

[Allen Browne]

You should be able to use an expression such as:
([F1] < 10) OR ([F1] > 10)
replacing F1 with your field name.

Less efficient would be:
Abs([F1]) > 10

We are assuming:
a) F1 is a Number field (not a Text field)
b) You set the Conditional Formatting to Expression.