Comapring two number fields with a differnce of 5 <>

[mezcalbean]

Hi trying to work out how to compare two number values but I want to highlight the difference of of 5 less and greater than ?

if{table1} <>5 {table1}} then '1' else '0'

thanks

 

[lbass]

If these are two fields in the same row and you want to highlight values where the absolute value is greater than 5, you could use a formula like this in the color (font color for field or detail section for the entire row) conditional formula area:

If abs(field1-field2)>5 then
Cryellow else
Crnocolor

If you are comparing values of the same field in different rows, the solution would be different.

-LB