Alternate Colors

[Mark G.]

Is there a way that if I select a range of lets say 140 rows and then want
to change the colors from white to something else that I could make it where
one row is one color while the next is another and then soforth with a
combination of maybe 2-4 colors or something. Even just alternating between
just 2 colors? If not built in, then is there a trick or script or something
that someone has that could assist with something like this? Would be much
appreciated. Thanks.

 

[Roger Govier]

Hi Mark

One way would be conditional formatting. Select the whole sheet by pressing
Ctrl+A
Format>Conditional Formatting>select Formula is from dropdown
In White pane type =MOD(ROW(),2)=0 for every other row
Format choose Patterns then the colouring you want
Click Add and repeat for
=MOD(ROW(),3)=0 for every third row, with a different colour.

Regards

Roger Govier

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)