I have a spread sheet with different colored rows. I want to drag a formula down a column with about 500 cells through the alternating colors. Is there a way that I can copy the formula without copying the color and thus changing the colors of the other cells?
When done dragging your formula and messing up all your colors a small square will appears near the place where you stopped dragging. Clicking this square will give you a couple of options, one of which will let you keep your format. When selecting that option your altered cells will get their original color back.