How do I fill every other line with a color?

[deann]

How do I fill every other line with color in an excel spreadsheet without
doing it line by line?

 

[ryguy7272]

This will give you what you want:
http://www.ozgrid.com/Excel/alternate-row-color.htm


Regards,
Ryan--

 

[deann]

I've tried that and it's not working? What am I doing wrong?

 

[FSt1]

hi
use conditional formating.
If formula is......=mod(row(),2)
pick your color.

Regards
FSt1

 

[deann]

I give up. I've tried highlighting the section that I want every other line
filled with color, selecting conditional formatting, selecting formula 1,
typing in =mod(row(),2)=0, selecting my pattern color, clicking ok, and
clicking ok again. It's not working. I've even tried it without
highlighting the section first. Also tried it without using the =0 part of
the formula.

Poo poo on this. hahaha

 

[Gord Dibben]

Select the number of rows to color...say 100.....then Format>Conditional
Fomatting>Formula is

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0 Format to a nice color.

This will retain the row formatting throughout sorting or filtering.


Gord Dibben MS Excel MVP

 

[Bob Phillips]

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

--
---
HTH

Bob

__________________________________________
UK Cambridge XL Users Conference 29-30 Nov
http://www.exceluserconference.com/UKEUC.html

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[JMB]

Bob - your follow-up post ended up in a new thread. I included the contents
of your post for the OP:


Sorry should be http://www.xldynamic.com/source/xld.CF.html#rows