How do I get every other row to highlight gray

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.

--
Don Guillett
SalesAid Software
donaldb@281.com
"Nancy C" <Nancy C@discussions.microsoft.com> wrote in message
news:7D44D022-3A18-48CE-9E76-B4AEA19891F8@microsoft.com...
> 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 C@discussions.microsoft.com> wrote in message
news:7D44D022-3A18-48CE-9E76-B4AEA19891F8@microsoft.com...
> I need every other row to be gray and if I insert a row I need the sheet
to
> correct the shading automatically