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?

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

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?

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

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?
>
>
>