Highlighting alternate rows

[NicoleS]

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)

 

[NicoleS]

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]

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

 

[Eduardo]

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]

Wonderful!! Thanks!

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]

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

 

[Gord Dibben]

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

 

[Max]

To CF likewise for columns, use:
=MOD(COLUMN(),2)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---