+ or - 20 difference. sierrachart.

[justanick]

hello
I'm working on Sierra chart, (charting software) that has is own excel built-in (sort of), please see the below documentation for further details. (array formulas or vba are not permitted)
See here for more information

the AA column is live market data, there is any formula that can help me to highlight if there is a (minimum) 20 + or - changes in the AA column? like if AA30 moves from 140 to 160 (or more, 165,167 whatever) or from 140 to 120 ???
I have probably worded my question in the wrong way, but please excuse myself since excels formulas are something totally new for me.

 

[steve the fish]

In Excel you would use something like

=ABS(A1-A2)>20

 

[etaf]

i this only with respect to the cell above it
so are we comparing Cell AA30 with the previous Cell AA29 for a + - 20 change

=ABS(AA1-AA2) > = 20
in a conditional format formula

 

[justanick]

Unfortunately none of your suggestions worked . But i appreciated the efforts, thank you so much

 

[etaf]

would you provide a sample, with expected results , maybe using XL2BB add-in - see signature/menu or via a share like dropbox , onedrive etc