Hi,

I need to be able to select a range of cells, and then press a button in a toolbox I have created.

When you press the button, the code goes through every cell selected, gets its value and changes its ColorIndex to the value in the cell.

But I have a problem...

I currently have this code:

Selection.Interior.ColorIndex = ActiveCell.Value

which works okay for singular cells. But if you select a range of more than 1 cell, it colours the entire range by the first number in it.

Can anyone help me get it so it will go through each cell individually and change each one to its appropiate colour?

Thanks very much! This will be a real help, I'm not sure how I would code such a thing yet.
I have never used "For" before which will probably be needed? And I'm not very good at arrays if those are needed either. Thanks again