Is there a way to automatically color every other row with a certain color?
Selecting each row individually is starting to make me go nutty.
Is there a way to automatically color every other row with a certain color?
Selecting each row individually is starting to make me go nutty.
http://cpearson.com/excel/banding.htm
Biff
"dramajuana" <[email protected]> wrote in message
news:[email protected]...
> Is there a way to automatically color every other row with a certain
> color?
> Selecting each row individually is starting to make me go nutty.
Select all rows.
Format>Conditional Formatting>Formula is: =MOD(ROW(),2)=1
Pick a pattern from Format and OK your way out.
Gord Dibben MS Excel MVP
On Sat, 10 Jun 2006 13:36:02 -0700, dramajuana
<[email protected]> wrote:
>Is there a way to automatically color every other row with a certain color?
>Selecting each row individually is starting to make me go nutty.
Gord Dibben MS Excel MVP
That works; thank you.
Now, is it possible to make that stop in, say, column E so that the pretty
colors don't continue on into infinity (or 256, whichever comes first)?
"Gord Dibben" wrote:
> Select all rows.
>
> Format>Conditional Formatting>Formula is: =MOD(ROW(),2)=1
>
> Pick a pattern from Format and OK your way out.
>
>
> Gord Dibben MS Excel MVP
>
>
> On Sat, 10 Jun 2006 13:36:02 -0700, dramajuana
> <[email protected]> wrote:
>
> >Is there a way to automatically color every other row with a certain color?
> >Selecting each row individually is starting to make me go nutty.
>
> Gord Dibben MS Excel MVP
>
=AND(COLUMN()<=5,MOD(ROW(),2)=1)
This code will make the colouring stop after column E. Adjust the number as you see fit.
Select just the range you want.
All of columns A:E or even A1:E9999
Then apply that conditional formatting.
dramajuana wrote:
>
> That works; thank you.
>
> Now, is it possible to make that stop in, say, column E so that the pretty
> colors don't continue on into infinity (or 256, whichever comes first)?
>
> "Gord Dibben" wrote:
>
> > Select all rows.
> >
> > Format>Conditional Formatting>Formula is: =MOD(ROW(),2)=1
> >
> > Pick a pattern from Format and OK your way out.
> >
> >
> > Gord Dibben MS Excel MVP
> >
> >
> > On Sat, 10 Jun 2006 13:36:02 -0700, dramajuana
> > <[email protected]> wrote:
> >
> > >Is there a way to automatically color every other row with a certain color?
> > >Selecting each row individually is starting to make me go nutty.
> >
> > Gord Dibben MS Excel MVP
> >
--
Dave Peterson
"dramajuana" wrote:
> ... is it possible to make that stop in, say, column E so that the pretty
> colors don't continue on into infinity (or 256, whichever comes first)?
Instead of selecting all rows,
try selecting only the range (say: select A1:D100)
before you apply the CF
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks