auto highlighting rows/columns

  • Thread starter Thread starter Jason Linan
  • Start date Start date
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
 
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.
 
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
 
Back
Top