Hi,
I have a list of data (columns A to F), where the value of A changes without a set pattern and I need to change background color the rows on the "breaks" on the values of column A. So the end-result should be a variant of alternating colors, but not on every second or third row.
Col A
A
A
A
B
B
C
C
C
C
D
E
E
F
Row 1-3 grey, row 4-5 white, row 6-9 grey, row 10 white, row 11-12 grey, row 13 white.
I have tried to read through all postings of CF, alternate coloring, countif's etc. but none seem to address this problem.
How can this be accomplished?
I have a list of data (columns A to F), where the value of A changes without a set pattern and I need to change background color the rows on the "breaks" on the values of column A. So the end-result should be a variant of alternating colors, but not on every second or third row.
Col A
A
A
A
B
B
C
C
C
C
D
E
E
F
Row 1-3 grey, row 4-5 white, row 6-9 grey, row 10 white, row 11-12 grey, row 13 white.
I have tried to read through all postings of CF, alternate coloring, countif's etc. but none seem to address this problem.
How can this be accomplished?