HEh. Run that GetColors sub post #10. Just set the column address to one next to your existing cells.

I remember seeing that Excel only uses the Colors in the Color Picker. If you RGB a cell, it actually uses the closest color in the Color Picker.

Compare to the two Colors you are using and replace the Color = RGB() with Interior.ColorIndex = #n