Highlighting Every Other Row Formula

A

Andrew Engelhart

I maintain a contact list of company names, contacts and
their respective phone numbers. Is there a quick formula
that I can apply to the entire sheet that will highlight
every other row so that each row stands out against the
next row when the sheet is printed?
 
A

Andy Brown

Is there a quick formula
that I can apply to the entire sheet that will highlight
every other row so that each row stands out against the
next row when the sheet is printed?
Click to expand...

You can use a conditional formatting formula -

=MOD(ROW(),2)=0

Rgds,
Andy
 
J

JulieD

Hi Andrew

one way
select your worksheet (or the used range) and choose
format / conditional formatting
select formula is and type
=MOD(ROW(),2)=0
click on format
go to Patterns, choose a fill colour
click OK twice

Hope this helps

Cheers
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Indenting every other paragraph in Word at the same time? 0
Finding Duplicate Rows & Highlighting them 6
Duplicate Mail Merge Record Every Time 5
Sports summary sheet - think I put this in wrong place originally 1
Highlight row 3
Change Color of Cell based on Date and today's date. 1
Color a cell based on column date and row content 2
How to shade groups of rows in excel. 1

Top