S
S Himmelrich
Column A has been sorted with a blank line after each unique entry. I
would like to format the first occurence in Column A as well as Column
B with a background color. Column B will continue with that color
until Column A has a different value, then a new color will be applied
for the next grouping.
This report is somewhat dynamic where there may be 5 to 20 uniques in
Column A so I need atleast the ability to use up to twenty colors,
which I can predefine in a case.
The example of what I'm trying to achieve is:
http://www.atlantissupport.com/example/example.xls
There is no code in the example above, it's just for example.
Does anyone have any ideas on how to do this?
would like to format the first occurence in Column A as well as Column
B with a background color. Column B will continue with that color
until Column A has a different value, then a new color will be applied
for the next grouping.
This report is somewhat dynamic where there may be 5 to 20 uniques in
Column A so I need atleast the ability to use up to twenty colors,
which I can predefine in a case.
The example of what I'm trying to achieve is:
http://www.atlantissupport.com/example/example.xls
There is no code in the example above, it's just for example.
Does anyone have any ideas on how to do this?