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?