Cell shading in every other line

[dstarr]

Hello,

I am trying to shade a color in every other line. I know I can jus
click on the row and press the fill button and it's done, but when
sort my data it scres everything up and the shading dollows the data
When I sort data I don't want the fill transfreing to another line.
am using the fill so I can see the lines easy. I have tried everyhtin
and I know their is a way to do it and I can't figure it out
Everybodys help is much appreicted.

Thanks - Da

 

[Peo Sjoblom]

Use conditional formatting, see:

http://www.cpearson.com/excel/banding.htm

 

[Bob Phillips]

Dan,

Conditional formatting is what you want.

Select all the rows
Go into Format>Conditional formatting
Change Condition1 to Formula Is
Add a formula of =MOD(ROW(),2)=1
Click format button
Select pattern tab
Select a pastel colour, like light green
Exit out

That's it

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi
select your rows and goto 'Format - conditional format'. Enter the
following:
=MOD(ROW(),2)=1

see also
http://www.cpearson.com/excel/banding.htm
for more about shading rows

Frank

 

[dstarr]

It worked, thank you very much