absolute value in conditional formatting

  • Thread starter Thread starter dballard
  • Start date Start date
D

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.
 
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.
 
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.
 
Back
Top