auto highlighting rows/columns

[Jason Linan]

Hello all-

Excel 2000 Professional or greater...

Instead of doing a macro or manually selecting a
row/column, is there a way to highlight, say, every other
column or row on a sheet automatically?

Thanks,
Jason

 

[Norman Harker]

Hi Jason!

It's called banding and can be achieved using conditional formatting
far more efficiently than manually because by using row numbers in the
formulas you don't have to manually adjust if you add or delete rows.

See:

Chip Pearson:
http://www.cpearson.com/excel/banding.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Gord Dibben]

Jason

Use Conditional Formatting to shade the rows. The alternate shading will
remain in place through sorting.

Select rows down as far as you want the shading.

Format>Conditional Formatting>Formula Is: =MOD(ROW(),2)=1

Pick a color and OK your way out.

Gord Dibben Excel MVP