Coloured rows

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Usaing excel 2000, how do I get alternate coloured rows without having to
select and colour each one??

Tim
 
Select all the rows you want coloured.
Use Format | Conditional Formatting
Use Formula is: and enter =MOD(ROW(),2)=1
and then set a pattern (colour for the alternate rows)
best wishes
 
Hi JoAnn,

The MOD function as used here gives the remainder of a division by 2 so will alternate per row between 0 and 1. It doesn't matter
if you test for 0 or for 1, that just determines which color the first row has.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| I've used the formula:
| =MOD(ROW(),2)=0
|
| I'm not very well versed in Excel formulas so forgive my ignorance. What the
| difference between =0 and =1?
|
| --
|
| JoAnn Paules
| MVP Microsoft [Publisher]
|
| ~~~~~
| How to ask a question
| http://support.microsoft.com/KB/555375
|
|
|
|
| | > Select all the rows you want coloured.
| > Use Format | Conditional Formatting
| > Use Formula is: and enter =MOD(ROW(),2)=1
| > and then set a pattern (colour for the alternate rows)
| > best wishes
| > --
| > Bernard V Liengme
| > www.stfx.ca/people/bliengme
| > remove caps from email
| >
| > | >>
| >> Usaing excel 2000, how do I get alternate coloured rows without having to
| >> select and colour each one??
| >>
| >> Tim
| >
| >
|
|
 
I didn't know you had a paper on conditional format. The traffic lights look like fun. More reading for me. Thanks.

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

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

For future reference
http://www.datapigtechnologies.com/flashfiles/alternateshading.html

You can also highlight every 5 rows or whatever number by changing the
formula.

Epinn


Usaing excel 2000, how do I get alternate coloured rows without having to
select and colour each one??

Tim
 
Back
Top