Here is the result I'm looking for in regards to changing color as
cell value changes in a column ("A"):

www.atlantissupport.com/example.example.xls

Basically I'm trying to change the background color of the cell as the
data changes in Column A. Know that the values in Column A change
dynamically with other macro code that is already completed. Also I
must pre-define enough colors to cover for expansion in the future
(probably no more then twenty). I've kept the duplicates in Column A
thinking that this may help in coding this macro and will delete those
after the background color is completed. I assume I can use offset
for moving the color to the smaller Column B.

Hope someone can help......

link correction: www.atlantissupport.com/example/example.xls