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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...

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