Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternating Color Rows
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternating Color Rows
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert cells in alternating rows? | Excel Worksheet Functions | |||
Alternating BG colors between groups of rows | Excel Discussion (Misc queries) | |||
shade alternating rows in excel | Excel Discussion (Misc queries) | |||
How do I set an auto alternating row color? | Excel Discussion (Misc queries) | |||
Alternating colors for rows | Excel Discussion (Misc queries) |