LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 27
Default Highlighting alternate rows

Hello,

I have a very long department phone list which I print & post near my phone.
I'd like an easy way to highlight every-other row to make it easier on the
eyes.

Currently I insert a column to the left of the table. Using the numbers 1 &
2, I alternately number every-other row all the way down the table.
Then I filter the 1's and highlight them.
Next, I remove the filter & every-other line is highlighted.

Is there a more simple or automatic way to do this? (When data is added in
the chart I have to adjust all the numbers)
 
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
Color alternate rows when after hiding selected rows Monk[_2_] Excel Worksheet Functions 6 June 7th 08 01:36 AM
sum alternate rows anand Excel Worksheet Functions 4 June 19th 07 07:59 AM
How to calculate the sum of the alternate rows? Sathish Excel Worksheet Functions 2 June 22nd 06 07:49 AM
Add alternate rows Teri Excel Worksheet Functions 6 March 16th 05 10:15 PM
How to sum-up alternate rows ? lolex Excel Worksheet Functions 3 November 5th 04 11:57 AM


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

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

About Us

"It's about Microsoft Excel"