View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 866
Default 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