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

formatconditional formatcondition 1formula is=mod(row(),2=0)format as
desired.

--
Don Guillett
SalesAid Software

"Nancy C" <Nancy wrote in message
...
I need every other row to be gray and if I insert a row I need the sheet
to
correct the shading automatically

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.

"Nancy C" wrote:

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

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

--

HTH

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


"Nancy C" <Nancy wrote in message
...
I need every other row to be gray and if I insert a row I need the sheet
to
correct the shading automatically