#1   Report Post  
eternal_cat via OfficeKB.com
 
Posts: n/a
Default Shades of Gray

Hello all, I want to shade every second row in gray. IS this possible?

Thank you :)

Chris.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200510/1
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

You could use format|conditional formatting
Chip Pearson explains it at:
http://www.cpearson.com/excel/banding.htm

Or maybe you could use:
Format|autoformat|list 1


"eternal_cat via OfficeKB.com" wrote:

Hello all, I want to shade every second row in gray. IS this possible?

Thank you :)

Chris.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200510/1


--

Dave Peterson
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
Gray Bar Taking up Half of Excel Window tgavin Excel Discussion (Misc queries) 1 July 17th 06 11:14 PM
In Excel, how do I rename the gray rows/columns (1,2,3/A,B,C)? rapunzel4040 Excel Discussion (Misc queries) 1 August 30th 05 10:35 PM
The merge center icon remains gray and does not work. mrspeaker Excel Discussion (Misc queries) 1 May 13th 05 03:42 AM
How do I get every other row to highlight gray Nancy C Excel Discussion (Misc queries) 3 March 8th 05 08:51 PM
Gray box appeared around images helenezs Excel Discussion (Misc queries) 0 January 13th 05 08:39 PM


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