How do I get every other row to highlight gray

[Nancy C]

I need every other row to be gray and if I insert a row I need the sheet to
correct the shading automatically

 

[Don Guillett]

format>conditional format>condition 1>formula is>=mod(row(),2=0)>format as
desired.

 

[Martin P]

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.

 

[Bob Phillips]

Take a look at http://www.xldynamic.com/source/xld.CF.html#rows

--

HTH

RP
(remove nothere from the email address if mailing direct)