Alternating Color Rows

's Computer Specifications

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

's Computer Specifications

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

"Gator" <(E-Mail Removed)> wrote in message
news:1F36268F-8437-40D8-AE49-(E-Mail Removed)...
> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formatting Alternating Rows with a Color	Daren	Microsoft Excel Worksheet Functions	8	30th Sep 2008 10:19 PM
Color alternating Rows	Dave	Microsoft Excel Discussion	2	27th Jun 2007 08:01 PM
Re: How do I get color on alternating record rows in Access 2000 Repor	fredg	Microsoft Access Reports	0	21st Sep 2004 12:34 AM
Shading alternating rows for easy visibilty - won't stay alternating when filtering	djmiller777	Microsoft Excel Misc	2	9th Jan 2004 09:48 PM
Filling alternating rows in a worksheet with color backgroud	Tom L	Microsoft Excel Programming	1	30th Oct 2003 10:52 PM