color change in a table
Hi,
I need to change the color of cells in a table to highlight a change in a
version per id.
the table is already orderd by id and version
For example
1 2 3 4
a id version grade Quatity
b 1 1 a 4
c 1 2 a 5
d 1 3 a 5
e 2 1 b 4
f 2 2 c 6
g 3 1 c 6
the colored cells should be:
c4 (quantity changed from 4 to 5) -- change in id 1 from version 1 to 2
and f3 (grade changed from b to c) and f4 (quantity changed from 4 to 6) --
change in id 2 from version 1 to 2
Any idea , please.
Thanks
|