How to select only odd/even numbered rows to be shaded

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with a pretty large worksheet and would like to select ONLY the
odd or even numbered rows so that i can shade them. Can someone offer #1 -
how to select these certain rows and #2 - how to format them?

Thanks
 

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

Shade even rows in a sheet 2
alternate row shading kept with autofilter 3
Conditional Formating based on Odd vs. Even 8
Select even or odd numbers 3
show fill color of a shaded row 3
Selection Shading gone from 07' ??? 1
How do I maintain alternate row shading after inserting a new row 4
how can I shade alternate rows in Excel 2007? 3

Back
Top