There is no VBA code in that sheet, nor is the Conditional Formatting applied
to the sheet. Simple review this web site:
http://www.contextures.com/xlCondFormat03.html

Then, apply to your specific needs:


Regards,
Ryan--
--
RyGuy


"S Himmelrich" wrote:

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......