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.

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


Mark G. wrote:
> 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.
>
>

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Mark G." <(E-Mail Removed)> wrote in message
news:erhtQ0j$(E-Mail Removed)...
> 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.
>
>