#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 21
Default Row Shading

I want to know if there is an easier way to shade alternating rows if I have
a long list of data. I want to alternate white/grey throughout the list,
however, when I sort the data or add new data, I do not want to have to redo
the row shading. Is there a way to set that up?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 21
Default Row Shading

Nevermind... I see this question has already been answered. Thank you.

"Gavin" wrote:

I want to know if there is an easier way to shade alternating rows if I have
a long list of data. I want to alternate white/grey throughout the list,
however, when I sort the data or add new data, I do not want to have to redo
the row shading. Is there a way to set that up?

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
Shading every other row Alan Excel Discussion (Misc queries) 8 May 17th 08 09:31 PM
3d shading Suzanne Charts and Charting in Excel 4 May 2nd 07 06:43 PM
Row Shading kthornton Excel Discussion (Misc queries) 3 July 18th 06 11:15 PM
Conditional Cell Shading (based on the shading of other cells) Tubby Excel Worksheet Functions 2 June 20th 06 10:03 PM
shading a rowwhen a time is entered but no shading when 0 is enter fomula problems Excel Worksheet Functions 7 October 23rd 05 08:44 PM


All times are GMT +1. The time now is 04:32 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"