I am analysing a large data worksheet (Sheet1) which consists of 21 columns (A-U) and over 35000 rows.
Data are sorted in groups of contiguous rows.
All data groups are contiguous, ie no empty rows separating them.
ColP reflects in its cells the number of rows of each group. So if a group is made up of three rows, ColP shows in each cell in its column, of that group, number 3 as demonstrated in Sheet1 of the attached example.
I am in need to:
- highlight each group of rows alternately in two different colours as per Sheet2 of the example, and
- highlight, in a third colour, ColP cells for the data group which are not in the same number as shown in those cells. As per Sheet2 of the example, cells P4-P12 are highlighed in blue because the group is of 9 rows not 11. The same applied on cells P24-P39 because the group is of 16 rows not 17 as shown in ColP.
Can I get some expert assistance with this need, please?
Many thanks in advance.
T.
Bookmarks