Cell shading in every other line

  • Thread starter Thread starter dstarr
  • Start date Start date
D

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
 
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)
 
Back
Top