Can somebody help me to change the background color of a cell depending on the color of another cell. I tried this:
Range("A1").Interior.Color = Range("A1").Interior.Color
It works. But my question is whether it can be done automatically? What i mean , is that every time I change the color in...