Do webdatarocks support realtime data update? Then once data gets updated then the cell color will change
Can I also create a custom measure, like converting measure from inches to a centimeter from the UI
Maybe you can try updateData API to implement dynamic data updates.
And you can also reference the following link for example.
By the way, the cell color will change when data change.