Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change the color of cells in the pivot table | Excel Discussion (Misc queries) | |||
Change the color of some cells in the pivot table | Excel Discussion (Misc queries) | |||
How do I change the color scheme of the autoformat for table 2? | Excel Discussion (Misc queries) | |||
change font color of first cell in data table attached to chart | Charts and Charting in Excel | |||
Change pivot Table color on Condition | Excel Programming |