Condition cells and data log

Copper Contributor

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!

 

Dace28_0-1612368908671.png

 

2 Replies

@Dace28 

You may add another conditional formatting rule with formula as here

image.png

without applying any format. Put the rule on first position and Stop if True.

@Sergei Baklan Thanks!