abdulhaque
Board Regular
- Joined
- Dec 2, 2015
- Messages
- 63
Hi all,
Just trying to think ahead of how best to tackle an upcoming task. What can I use to highlight differences in groups of cells in a row? In the example below, you can see two tables, table A = columns A-E and table B = columns G-K. Any row between each table, if found in both tables they are not highlighted. If a row is found in table A but not in table B, the row in table A is highlighted in red. Likewise if a row is found in table B but not in table A, the row in table B is highlighted in blue. The cells can contain anything, including numbers, characters, dates etc. Filtering can be applied by any column.
Thanks
<tbody>
</tbody>
Just trying to think ahead of how best to tackle an upcoming task. What can I use to highlight differences in groups of cells in a row? In the example below, you can see two tables, table A = columns A-E and table B = columns G-K. Any row between each table, if found in both tables they are not highlighted. If a row is found in table A but not in table B, the row in table A is highlighted in red. Likewise if a row is found in table B but not in table A, the row in table B is highlighted in blue. The cells can contain anything, including numbers, characters, dates etc. Filtering can be applied by any column.
Thanks
A | B | C | D | E | F | G | H | I | J | K | |
1 | a | b | 1 | 2 | 3 | y | y | y | y | 6 | |
2 | 3 | 4 | h | t | c | 3 | 4 | h | t | c | |
3 | t | j | d | 7 | 6 | h | h | h | h | h | |
4 | o | o | o | o | o | a | b | 1 | 2 | 3 | |
5 | 1 | 2 | 3 | 4 | 5 | 5 | j | j | j | p | |
6 | y | y | y | y | 6 | f | g | h | i | j | |
7 | h | h | h | h | h | 4 | 5 | 7 | 8 | ||
8 | d | h | d | 2 | 5 | 1 | 2 | 3 | 4 | 5 | |
9 | f | g | h | i | j | e | y | 6 | l | o | |
10 | 4 | 5 | 7 | 8 | o | o | o | o | o |
<tbody>
</tbody>