RE: Shade alternate lines

=?Utf-8?B?TWFydGluIFA=?=

Guest

Posts: n/a

16th Dec 2004

Conditionally format cell A1 with Formula is =INT(ROW(A1)/2)<>ROW(A1)/2,
choose a pattern and copy the format to the entire worksheet.

"wyattf" wrote:

> How can you shade alternate lines on a worksheet in order to make the result
> more readable?

« Day of the week | adding an option to the right click menu »

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Shade Active Cell - Shade the cell the cursor is in only while in	=?Utf-8?B?TGlzYQ==?=	Microsoft Excel Programming	2	17th Apr 2007 10:00 PM
how do I shade alternate lines of text	=?Utf-8?B?TmlmdHk=?=	Microsoft Word Document Management	1	31st May 2005 03:04 AM
shade messages from alternate days (Today, no; Yesterday, shade)	=?Utf-8?B?Z2Vla2FuZ2Vs?=	Microsoft Outlook Installation	0	17th May 2005 07:01 PM
Re: Shade alternate lines	Frank Kabel	Microsoft Excel Misc	0	16th Dec 2004 05:33 PM
Shade alternate lines in a report...without code!	Joe	Microsoft Access Reports	3	4th May 2004 03:50 PM