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

color change in a table
 

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.

"Dan" wrote:

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

color change in a table
 

Thanks

"andy62" wrote:

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.

"Dan" wrote:

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