ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   vary row colors in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/101439-vary-row-colors-excel.html)

bob the bolder

vary row colors in excel?
 
To view spread sheets easier I would like to have every other row a different
color. ie white /gray.
Is there a simple function I can ckick or must I go to every other row and
select the back ground color I want.

Any help would be appreciated.

Ron Coderre

vary row colors in excel?
 
Visit this excellent website that gives instructions for what you described:

http://www.xldynamic.com/source/xld.CF.html#rows

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"bob the bolder" wrote:

To view spread sheets easier I would like to have every other row a different
color. ie white /gray.
Is there a simple function I can ckick or must I go to every other row and
select the back ground color I want.

Any help would be appreciated.



All times are GMT +1. The time now is 11:31 AM.

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