Hello,

I have a very long department phone list which I print & post near my phone.
I'd like an easy way to highlight every-other row to make it easier on the
eyes.

Currently I insert a column to the left of the table. Using the numbers 1 &
2, I alternately number every-other row all the way down the table.
Then I filter the 1's and highlight them.
Next, I remove the filter & every-other line is highlighted.

Is there a more simple or automatic way to do this? (When data is added in
the chart I have to adjust all the numbers)

One play is to use conditional formatting (CF)
Select the entire sheet (or the range),
then apply CF using Formula Is:
=MOD(ROW(),2)
Format the fill to suit OK out

voila? click the yes button below to express your success
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---


"NicoleS" wrote:

Hello,

I have a very long department phone list which I print & post near my phone.
I'd like an easy way to highlight every-other row to make it easier on the
eyes.

Currently I insert a column to the left of the table. Using the numbers 1 &
2, I alternately number every-other row all the way down the table.
Then I filter the 1's and highlight them.
Next, I remove the filter & every-other line is highlighted.

Is there a more simple or automatic way to do this? (When data is added in
the chart I have to adjust all the numbers)

Thank you Max, but I don't understand how/where to enter the formula?
I tried to enter it on the formula bar, but nothing happened.

I looked up "conditional formatting" then found it under the formatting menu
& tried to fill that in, but there was no space for a formula.



"Max" wrote:

One play is to use conditional formatting (CF)
Select the entire sheet (or the range),
then apply CF using Formula Is:
=MOD(ROW(),2)
Format the fill to suit OK out

voila? click the yes button below to express your success
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---


"NicoleS" wrote:

Hello,

I have a very long department phone list which I print & post near my phone.
I'd like an easy way to highlight every-other row to make it easier on the
eyes.

Currently I insert a column to the left of the table. Using the numbers 1 &
2, I alternately number every-other row all the way down the table.
Then I filter the 1's and highlight them.
Next, I remove the filter & every-other line is highlighted.

Is there a more simple or automatic way to do this? (When data is added in
the chart I have to adjust all the numbers)

In excel 03, select the range, then click Format Conditional Formatting
Under Condition 1, click the droplist, select "Formula Is:" option
Then paste the suggested formula into the box next to it
Click Format button, format to taste Ok out
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"NicoleS" wrote:
Thank you Max, but I don't understand how/where to enter the formula?
I tried to enter it on the formula bar, but nothing happened.

I looked up "conditional formatting" then found it under the formatting menu
& tried to fill that in, but there was no space for a formula.

Hi,
In conditional formating you have an option that says "Where the formula
is", there you have to go and enter the formula given by Max

"NicoleS" wrote:

Thank you Max, but I don't understand how/where to enter the formula?
I tried to enter it on the formula bar, but nothing happened.

I looked up "conditional formatting" then found it under the formatting menu
& tried to fill that in, but there was no space for a formula.



"Max" wrote:

One play is to use conditional formatting (CF)
Select the entire sheet (or the range),
then apply CF using Formula Is:
=MOD(ROW(),2)
Format the fill to suit OK out

voila? click the yes button below to express your success
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---


"NicoleS" wrote:

Hello,

I have a very long department phone list which I print & post near my phone.
I'd like an easy way to highlight every-other row to make it easier on the
eyes.

Currently I insert a column to the left of the table. Using the numbers 1 &
2, I alternately number every-other row all the way down the table.
Then I filter the 1's and highlight them.
Next, I remove the filter & every-other line is highlighted.

Is there a more simple or automatic way to do this? (When data is added in
the chart I have to adjust all the numbers)

Wonderful!! :) Thanks!

"Max" wrote:

In excel 03, select the range, then click Format Conditional Formatting
Under Condition 1, click the droplist, select "Formula Is:" option
Then paste the suggested formula into the box next to it
Click Format button, format to taste Ok out
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"NicoleS" wrote:
Thank you Max, but I don't understand how/where to enter the formula?
I tried to enter it on the formula bar, but nothing happened.

I looked up "conditional formatting" then found it under the formatting menu
& tried to fill that in, but there was no space for a formula.

One more thing...
I see there is a similar question posted about highlighting columns.
Is there a place where we could reference the formulas?
You guys are so smart to know them & rattle them off so easily.

Thanks again :)

"NicoleS" wrote:

Wonderful!! :) Thanks!

"Max" wrote:

In excel 03, select the range, then click Format Conditional Formatting
Under Condition 1, click the droplist, select "Formula Is:" option
Then paste the suggested formula into the box next to it
Click Format button, format to taste Ok out
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"NicoleS" wrote:
Thank you Max, but I don't understand how/where to enter the formula?
I tried to enter it on the formula bar, but nothing happened.

I looked up "conditional formatting" then found it under the formatting menu
& tried to fill that in, but there was no space for a formula.

If you will want to be able to filter the list of phone numbers you will
want to use

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0

Max's formula will not follow filtered rows.


Gord Dibben MS Excel MVP

On Wed, 17 Jun 2009 10:12:02 -0700, Max wrote:

One play is to use conditional formatting (CF)
Select the entire sheet (or the range),
then apply CF using Formula Is:
=MOD(ROW(),2)
Format the fill to suit OK out

voila? click the yes button below to express your success

To CF likewise for columns, use:
=MOD(COLUMN(),2)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"NicoleS" wrote:
One more thing...
I see there is a similar question posted about highlighting columns.
Is there a place where we could reference the formulas?
You guys are so smart to know them & rattle them off so easily.

Thanks again :)

"NicoleS" wrote:

Wonderful!! :) Thanks!