Plus or minus 5%

[cterrell16]

Can the conditional formatting be used to highlight a field when you want to show if a field is plus or minus 5%?

[comment]

25 minutes ago, cterrell16 said:

a field is plus or minus 5%?

plus or minus 5% relative to what?

[cterrell16]

I have a field that has a set point of 100.  The second field is a reading we enter, in this case say 80.  I want the third field to turn red if it's +/- 5% off.  With 80 it should turn red.  At 96 its ok, hence not red.  

Edited June 7, 2016 by cterrell16

[comment]

36 minutes ago, cterrell16 said:

I have a field that has a set point of 100.

I trust that 100 is only an example, and that the field can have other values? Otherwise, why would you need it at all?

Anyway, If the first field is named Reference and the second field is named Value, you can base your conditional formatting on the formula =

Abs ( Value / Reference - 1 ) > .05

 

Edited June 7, 2016 by comment

[cterrell16]

You the man.  Thanks.