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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Tim" wrote in message
...

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

Tim

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




"Bernard Liengme" wrote in message
...
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

"Tim" wrote in message
...

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

Tim

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

"JoAnn Paules [MVP]" wrote in message ...
| 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
|
|
|
|
| "Bernard Liengme" wrote in message
| ...
| 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
|
| "Tim" wrote in message
| ...
|
| Usaing excel 2000, how do I get alternate coloured rows without having to
| select and colour each one??
|
| Tim
|
|
|
|

Aha............thank you. :-)

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375




"Niek Otten" wrote in message
...
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

"JoAnn Paules [MVP]" wrote in message
...
| 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
|
|
|
|
| "Bernard Liengme" wrote in message
| ...
| 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
|
| "Tim" wrote in message
| ...
|
| Usaing excel 2000, how do I get alternate coloured rows without
having to
| select and colour each one??
|
| Tim
|
|
|
|

JoAnn Paules [MVP] wrote:

Aha............thank you. :-)


It so simple when you know how!!

Thanks guys

Tim

For future reference http://www.datapigtechnologies.com/f...teshading.html

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

Epinn

"Tim" wrote in message ...

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

Tim

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

--

HTH

Bob Phillips

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

"Epinn" wrote in message
...
For future reference
http://www.datapigtechnologies.com/f...teshading.html

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

Epinn

"Tim" wrote in message
...

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.

"Bob Phillips" wrote in message ...
or http://xldynamic.com/source/xld.CF.html#rows

--

HTH

Bob Phillips

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

"Epinn" wrote in message
...
For future reference
http://www.datapigtechnologies.com/f...teshading.html

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

Epinn

"Tim" wrote in message
...

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

Tim