I am display a query in a datasheet and, based on a column's value I want to be able
to change the background color for the row that contains the value.
Based on the values of column Key, I need to set each row's background color
to red, green or orange if the value of Key for that row is <0, =0 or >0 respectively.
The datasheet view:
-1 Some comment <-- Background needs to be RED
-4 Some other date <-- Background needs to be RED
0 More data <-- Background needs to be GREEN
3 Testing <-- Background needs to be ORANGE
5 Aaaaaaa <-- Background needs to be ORANGE
It doesn't need to be a datasheet view, I'm happy to use a tabular form layout if
this can be achieved that way. (or any other way for that matter).
The closest I've come to this functionality is the format property
but that only changes the foreground color of the control to which it is applied.
Appreciate your help