Condition cells and data log

New 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




Thank you!




2 Replies


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.

@Sergei Baklan Thanks!