PC Review


Reply
Thread Tools Rate Thread

How can I shade each alternate Excel row without selecting each?

 
 
=?Utf-8?B?QXVzaSBEcmV3?=
Guest
Posts: n/a
 
      21st Sep 2007
I just want to shade every second row in a large spreadsheet to improve
readability but without invoking a full style. How can that be done?
 
Reply With Quote
 
 
 
 
RichardSchollar
Guest
Posts: n/a
 
      21st Sep 2007
On 21 Sep, 07:54, Ausi Drew <Ausi D...@discussions.microsoft.com>
wrote:
> I just want to shade every second row in a large spreadsheet to improve
> readability but without invoking a full style. How can that be done?


Hi

Assuming you haven't already applied any Conditional Formatting, then
this would be one way to achieve this. The following applies to the
steps to take in xl2003:

1. Select the used area in your worksheet (eg a1:Z100) and go
Format>Conditional Formatting
2. Change to Formula Is in the left hand side dropdown and type in the
following formula:

=MOD(ROW(),2)=1

and hit the Format button and apply the fill colour of your choice -
this will colour odd rows the selected colour.

Hope this helps!

Richard

 
Reply With Quote
 
MartinW
Guest
Posts: n/a
 
      21st Sep 2007
Hi Drew,

Take a look here.
http://xldynamic.com/source/xld.CF.html

HTH
Martin


"Ausi Drew" <Ausi (E-Mail Removed)> wrote in message
newsBF9ADE3-548F-4607-92B5-(E-Mail Removed)...
>I just want to shade every second row in a large spreadsheet to improve
> readability but without invoking a full style. How can that be done?



 
Reply With Quote
 
=?Utf-8?B?QXVzaSBEcmV3?=
Guest
Posts: n/a
 
      21st Sep 2007
Richard ... a most excellent solution. Grateful thanks.

"RichardSchollar" wrote:

> On 21 Sep, 07:54, Ausi Drew <Ausi D...@discussions.microsoft.com>
> wrote:
> > I just want to shade every second row in a large spreadsheet to improve
> > readability but without invoking a full style. How can that be done?

>
> Hi
>
> Assuming you haven't already applied any Conditional Formatting, then
> this would be one way to achieve this. The following applies to the
> steps to take in xl2003:
>
> 1. Select the used area in your worksheet (eg a1:Z100) and go
> Format>Conditional Formatting
> 2. Change to Formula Is in the left hand side dropdown and type in the
> following formula:
>
> =MOD(ROW(),2)=1
>
> and hit the Format button and apply the fill colour of your choice -
> this will colour odd rows the selected colour.
>
> Hope this helps!
>
> Richard
>
>

 
Reply With Quote
 
=?Utf-8?B?QXVzaSBEcmV3?=
Guest
Posts: n/a
 
      21st Sep 2007
Thanks Martin ... excellent explanation. Most thankful.

"MartinW" wrote:

> Hi Drew,
>
> Take a look here.
> http://xldynamic.com/source/xld.CF.html
>
> HTH
> Martin
>
>
> "Ausi Drew" <Ausi (E-Mail Removed)> wrote in message
> newsBF9ADE3-548F-4607-92B5-(E-Mail Removed)...
> >I just want to shade every second row in a large spreadsheet to improve
> > readability but without invoking a full style. How can that be done?

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can I shade alternate rows in Excel 2007? lingo123 Microsoft Excel Misc 3 25th Nov 2007 10:50 PM
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 =?Utf-8?B?TWFydGluIFA=?= Microsoft Excel Misc 0 16th Dec 2004 07:03 PM
Re: Shade alternate lines Frank Kabel Microsoft Excel Misc 0 16th Dec 2004 04:33 PM
How do I shade alternate rows in Excel 2002? =?Utf-8?B?ZHJ1bW1lcmdpcmw3Mw==?= Microsoft Excel Misc 2 29th Nov 2004 09:17 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:13 PM.