auto highlighting rows/columns

J

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
 
N

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
G

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
 
Top