Feb 03 2021 08:19 AM
Hi, I have this real time data comming from a OPC but it's only real time, does anyone know how to store it?, also I have a 2 scale color condition to make it more friendly but how do I avoid using the "0" values?
Just in case it matters... this is the formula on B3 from where I get the data
=RSLINX|OP010_470!'Program:OP040_MH.TimeLog[0],L100,C1'
Thank you!
Feb 03 2021 02:20 PM
You may add another conditional formatting rule with formula as here
without applying any format. Put the rule on first position and Stop if True.