change background color of cell as data in column changes

S

S Himmelrich

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change background color of cell as value changes 4
Change background color when value changes in a column. 2
Cell Background Color Change --> Change Event 5
Remove Hyperlinks Without Changing background shading 14
Change background based on value in another column 5
Note related background color of a cell 4
How to do when the Cell is in color jump to next cell? 2
Change the background color of cells once it being edited 2

Top