View Single Post
  #4   Report Post  
g wills
 
Posts: n/a
Default

Thank you!
That worked.

g willis

On Fri, 3 Dec 2004 00:15:37 +0800, "JulieD"
wrote:

Hi

yes, select your worksheet and choose
format / conditional formatting
choose
formula is
type
=ROW()=ODD(ROW())
click on the format button, go to the patterns tab, choose a fill colour
click OK twice

Cheers
JulieD

"g wills" wrote in message
.. .
1st time using excel....

I want to make a wrestling roster to keep the wrestlers weights for
each day. I would like to have a wrestler's name and weight of each
day in a row. To make it easier to see, I would like for every other
row to have a grey shade (like stripes). When I sort, the shade goes
with the text.

Is there anyway to make a shade on each other row and still be able to
sort?