Row background colours

D

dramajuana

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.
 
G

Gord Dibben

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


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.
Click to expand...

Gord Dibben MS Excel MVP
 
D

dramajuana

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)?
 
D

Dave Peterson

Select just the range you want.

All of columns A:E or even A1:E9999

Then apply that conditional formatting.
 
K

KellTainer

=AND(COLUMN()<=5,MOD(ROW(),2)=1)

This code will make the colouring stop after column E. Adjust th
number as you see fit
 
M

Max

dramajuana said:
... 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)?
Click to expand...

Instead of selecting all rows,
try selecting only the range (say: select A1:D100)
before you apply the CF
 
Top