How can I shade every other row in Spreadsheet automatically?

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

Guest

I would like this to auto format based on all odd or even numbered rows for
easier viewing of a task list. Sometimes items (rows) are deleted or added.
Can this autoformat?
 
one common way to do this is select all <Format><Conditonal format>
<Equation = > = mod (Row(A1),2)=1 then select your prefered color
note you sometimes need to go back in and get rid of Quote marks or absolute
cell references. I do not know why.
 
You must log in or register to reply here.

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

how can I shade alternate rows in Excel 2007? 3
Shade Every Other Row 2
Shaded for every other row 2
How to reset every other row color after sorting 2
shading alternate rows, but losing format when one row is deleted 8
Deleting Every Other Row 1
How to stop automatic cell shading 3
autoformat add or change 1

Back
Top