RTD (real time data) cell format condition increase decrease cell value

asked 2017-02-21 19:22:59 +0200

JG101 gravatar image

updated 2017-02-22 21:59:51 +0200

I'm using an RTD (Real Time Data) sheet. numbers increase / decrease all the time. I'm trying to implement a Format condition for some reason its not working.

I would like the cell if the RTD data is greater than prev data it will show green, if data is less than prev data it will show red, if data is the same will show yellow. at this moment its only showing Yellow, it's not recognizing the change in data value.

I initially referenced to this page from earlier discussion and applied same concept but it did not work. https://ask.libreoffice.org/en/questi... anyone have any ideas, thank you in advance


updated: Providing data sheet will do no good unless u have software that updates data. Is there a way to have a cell change conditional format upon itself with Real Time Data.

ie. column A row 1 = 10

data A1 changes to 11 I would like the cell to change Green

data A1 changes to 9 I would like the cell to change RED

A1 cell is highlighted cell value is greater than > current A1 cell value background changes Green

A1 cell value is less than > current A1 cell value background changes Red

A1 cell value is equal to = current A1 cell data background changes white

edit retag flag offensive close merge delete

Comments

Please attach a sample file. So it can be studied what is wrong.

m.a.riosv gravatar imagem.a.riosv ( 2017-02-21 22:09:36 +0200 )edit

Could you provide more information about the real time data sheet, i.e. who, what, how, etc. Thanks.

EasyTrieve gravatar imageEasyTrieve ( 2017-02-22 00:30:55 +0200 )edit

Providing data sheet will do no good unless u have software that updates data. Is there a way to have a cell change conditional format upon itself with Real Time Data. ie. column A row 1 = 10 when data A1 changes to 11 I would like the cell to change Green when data A1 changes to 9 I would like the cell to change RED

A1 cell is highlighted cell value is greater than > A1 background Green cell value is less than > A1 background Red cell value is equal to > A1 background white

JG101 gravatar imageJG101 ( 2017-02-22 19:39:09 +0200 )edit