stefanaalten
Board Regular
- Joined
- Feb 1, 2011
- Messages
- 68
- Office Version
- 365
- Platform
- Windows
Hi,
I would like to use conditional formatting to format rows and groups of rows as per the example shown below. I have provided three separate examples in the screenshot to illustrate what I'm trying to produce. Each table is supposed to represent a very simplified version of my data. The first table represents the default view, in which rows are ordered by ID (which is not unique for each row). Some columns contain data which is the same for all rows in a certain group, for example Info 1 and Info 2 are always the same for a given ID. Other columns, for example Info 3 and Info 4 contain data which is specific for that row, within that ID. In the default ordering I would like to have colours for rows and groups of rows as shown, to make it easy to distinguish between the pieces (Star Wars, Lord of the Rings, etc.) and within the pieces between the parts (Flute, etc.) Now the tricky bit ... I will often apply a different sort ordering from the default - see the 2nd and 3rd examples in the screenshot, where the table is ordered on Info 2 and Info 3 respectively - and I want to retain the colouring from the default sort order (the first table).
My actual data is across many more columns and rows - below is a highly simplified illustration. Many thanks in advance for any help!
I would like to use conditional formatting to format rows and groups of rows as per the example shown below. I have provided three separate examples in the screenshot to illustrate what I'm trying to produce. Each table is supposed to represent a very simplified version of my data. The first table represents the default view, in which rows are ordered by ID (which is not unique for each row). Some columns contain data which is the same for all rows in a certain group, for example Info 1 and Info 2 are always the same for a given ID. Other columns, for example Info 3 and Info 4 contain data which is specific for that row, within that ID. In the default ordering I would like to have colours for rows and groups of rows as shown, to make it easy to distinguish between the pieces (Star Wars, Lord of the Rings, etc.) and within the pieces between the parts (Flute, etc.) Now the tricky bit ... I will often apply a different sort ordering from the default - see the 2nd and 3rd examples in the screenshot, where the table is ordered on Info 2 and Info 3 respectively - and I want to retain the colouring from the default sort order (the first table).
My actual data is across many more columns and rows - below is a highly simplified illustration. Many thanks in advance for any help!
Last edited: