Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
drummergirl73
 
Posts: n/a
Default How do I shade alternate rows in Excel 2002?

I used to be able to do this quite easily in Lotus 123 eight years ago. How
can I do this without having to individually select alternate rows to shade
in a large spreadsheet?
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

drummer

See Chip Pearson's site for color banding using Conditional Formatting

http://www.cpearson.com/excel/banding.htm

Gord Dibben Excel MVP

On Mon, 29 Nov 2004 12:05:03 -0800, "drummergirl73"
wrote:

I used to be able to do this quite easily in Lotus 123 eight years ago. How
can I do this without having to individually select alternate rows to shade
in a large spreadsheet?


  #3   Report Post  
Martin P
 
Posts: n/a
Default

In cell A1 go to Format, Conditional Formatting.
Under Condition 1 choose Formula Is and type =row(a1)/2=int(row(a1)/2).
Click Format, click the Patterns tab, choose your shading colour, click OK
and click OK again.
Copy the format to all the other cells.

"drummergirl73" wrote:

I used to be able to do this quite easily in Lotus 123 eight years ago. How
can I do this without having to individually select alternate rows to shade
in a large spreadsheet?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Histogram in Excel (2002) Maxiem Charts and Charting in Excel 2 January 18th 05 02:43 AM
How do I display a data table in an Excel 2002 chart? Dr. Mark F. Charts and Charting in Excel 3 December 29th 04 04:04 PM
Report Manager in Excel 2002 Misha Excel Discussion (Misc queries) 2 November 28th 04 07:59 AM


All times are GMT +1. The time now is 06:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"