Wanting to have the block change to a light red while the figures go dark red when the numbers go negative.
Dear Jack Footer,
you mean something like this ?
This is no standard function of the dataview itself. To get it work, you need 2 DataViews overlaying each other.
For the one in Front you enable the transparency (in my case to 30%)
In my case, the one in the front displays the background color and the one in the back the figures color.
Hope it helps.
Retrieving data ...