You could try Conditional Formatting, using =MOD(ROW(),2)
--
David Biddulph

"Gator" wrote in message
...
How can I make alternating colored rows like white, blue, white, blue,
white,
blue..... so that when I drag a cell to another location.....the original
color will hold instead of changing to the color that was dragged from the
other cell.
--
Gator