color change in a table

[Guest]

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

 

[Guest]

Hi Dan - If I am understanding correctly, I think you could use conditional
formatting to highlight the cells. Your example seems to exclude some of the
changes, so maybe I am oversimplifying this. But if not, try this: select
cell B3, go to conditional formatting (Format >> Conditional Formatting),
change the drop-down to "Formula Is", then in the condition space type:

=B3<>B2

Then set up a highlighting condition (such as cell background = yellow), and
press "Okay".

Now use the format painter to apply that conditional formatting to all other
cells except the header row and the first row of data.

This checks to see whether a cell's value is different from the one above
it. Your row/column numbering/lettering was reversed, so I switched it in my
instructions. If that doesn't work, write back.

 

[Guest]

Thanks

Hi Dan - If I am understanding correctly, I think you could use conditional
formatting to highlight the cells. Your example seems to exclude some of the
changes, so maybe I am oversimplifying this. But if not, try this: select
cell B3, go to conditional formatting (Format >> Conditional Formatting),
change the drop-down to "Formula Is", then in the condition space type:

=B3<>B2

Then set up a highlighting condition (such as cell background = yellow), and
press "Okay".

Now use the format painter to apply that conditional formatting to all other
cells except the header row and the first row of data.

This checks to see whether a cell's value is different from the one above
it. Your row/column numbering/lettering was reversed, so I switched it in my
instructions. If that doesn't work, write back.