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

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?

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

On 21 Sep, 07:54, Ausi Drew <Ausi
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
FormatConditional 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

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

Hi Drew,

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

HTH
Martin


"Ausi Drew" <Ausi wrote in message
...
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?

How can I shade each alternate Excel row without selecting eac
 

Richard ... a most excellent solution. Grateful thanks.

"RichardSchollar" wrote:

On 21 Sep, 07:54, Ausi Drew <Ausi
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
FormatConditional 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

How can I shade each alternate Excel row without selecting eac
 

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 wrote in message
...
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?