Sorry to be misleading on that. The example was for purposes of
demonstrating the final result. I'm already in macro mode as far as
the final results of that speadsheet, so conditional formatting is not
what I'm looking for. The referenced website you provided does not
address changing colors as values change so that isn't providing
anymore insight to my challenge. Thank you for effort and response.


On Jan 15, 11:41*am, ryguy7272
wrote:
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......- Hide quoted text -

- Show quoted text -