How do I get every other row to highlight gray

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

Guest

I need every other row to be gray and if I insert a row I need the sheet to
correct the shading automatically
 
format>conditional format>condition 1>formula is>=mod(row(),2=0)>format as
desired.
 
In cell A1: Format, Conditional Formatting. Let the condition be Formula is
=mod(row(a1),2)=0. Choose the colour under Patterns.
Use Edit, Paste Special to copy the formatting to the entire worksheet.
 
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

Highlight exact match in column and count 2
Unwanted shading of entire spreadsheet 2
Need to highlight cells in special order 0
Conditional Formatting Help 3
Shading every other row 8
Shaded for every other row 2
How do I create alternating row colors in excel? 5
Automatically Highlight every 22nd row 2

Back
Top