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

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

RichardSchollar

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how can I shade alternate rows in Excel 2007? 3
formula for CF 5
shade rows 2
Use VBA to shade every 3 rows (banding) 6
How do I shade alternate rows in Excel 2002? 2
If using =MOD(ROW(),2)=0 conditional formatting and want diff fill 1
How do I get row and column of active cell to highlight? 2
how do you shade every othe row in excel 2007 2

Top