Ok, I tried using cpearson's website and it was just way to complicated for
me to understand. I need every other row coloured tan and all the others
white. I also need them to stay that way when I sort. I need this to start in
row 3. What would be the formula or what else would I do?

God Bless,
Harley

"Debra Dalgleish" wrote:

You could use conditional formatting to colour the rows. Chip Pearson
has instructions on his web site:

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

evas1ve wrote:
I have applied specific colors to specifc rows, but when i sort the colored
rows follow the sorting format.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html