ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I make a spreadsheet that skips each cell and adds color (https://www.excelbanter.com/excel-discussion-misc-queries/70139-how-do-i-make-spreadsheet-skips-each-cell-adds-color.html)

PeterM

How do I make a spreadsheet that skips each cell and adds color
 
What I actually mean, I like to have green every other cell, for about 125
cells, is there a way to , not with VBA, I can't get that into my senior
citizen head.......Peter



Dave Peterson

How do I make a spreadsheet that skips each cell and adds color
 
If you're not using conditional formatting, maybe you can use it for this. Chip
Pearson explains it all:
http://cpearson.com/excel/banding.htm



PeterM wrote:

What I actually mean, I like to have green every other cell, for about 125
cells, is there a way to , not with VBA, I can't get that into my senior
citizen head.......Peter


--

Dave Peterson


All times are GMT +1. The time now is 11:33 PM.

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