T
Tim
Usaing excel 2000, how do I get alternate coloured rows without having to
select and colour each one??
Tim
select and colour each one??
Tim
B
Bernard Liengme
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
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
J
JoAnn Paules [MVP]
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
=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
N
Niek Otten
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
| >
| >
|
|
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
| >
| >
|
|
J
JoAnn Paules [MVP]
Aha............thank you. 
--
JoAnn Paules
MVP Microsoft [Publisher]
~~~~~
How to ask a question
http://support.microsoft.com/KB/555375
--
JoAnn Paules
MVP Microsoft [Publisher]
~~~~~
How to ask a question
http://support.microsoft.com/KB/555375
T
Tim
JoAnn said:Aha............thank you.
It so simple when you know how!!
Thanks guys
Tim
J
JoAnn Paules [MVP]
Most things are.
--
JoAnn Paules
MVP Microsoft [Publisher]
~~~~~
How to ask a question
http://support.microsoft.com/KB/555375
--
JoAnn Paules
MVP Microsoft [Publisher]
~~~~~
How to ask a question
http://support.microsoft.com/KB/555375
E
Epinn
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
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
B
Bob Phillips
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
--
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
E
Epinn
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
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