ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Shades of Gray (https://www.excelbanter.com/excel-worksheet-functions/50353-shades-gray.html)

eternal_cat via OfficeKB.com

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

Dave Peterson

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


All times are GMT +1. The time now is 10:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com