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

[JG101]

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.

Conditional format : each row each cell

How do I create Conditional Formatting – (individual rows)to color code each cell: If cell is Less than prev cell = light RED or if cell is Greater than prev cell = light Green how can I write this for each Row / cell ? also how do I copy conditional format and implement into row:cell without overriding data in cell. Or do I need to implement formula conditional format before entering data into cell. thank you in advance see document conditional format each row each cell 02-13-2017.ods

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

[mariosv]

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

[EasyTrieve]

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

[JG101]

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