AAHH HAAA!! Conditional formatting. That is what I was missing!! I was typing
in the formula. Yep, that was what I meant, and your advice did the trick.
Thank you.
God Bless,
Harley

"Myrna Larson" wrote:

You can use Conditional Formatting to color, say, odd numbered rows. But if
you sort the data, and what was row 3 now moves to row 4, it will no longer be
colored. Is that what you want?

If so, the formula to use with Conditional Formatting is =MOD(ROW(),2)=1 to
color odd rows. Change the 1 to 0 to color even rows.


On Sun, 30 Jan 2005 19:07:02 -0800, Crowraine
wrote:

1. Because I don't know the name exactly of what I am needing done.. for
example banding or locking.
2. I tried the formula as he explained and it didn't work for me.
3. Maybe someone else could re-state it in a way that would more helpful.
That is why someone here might be able to explain it better. There is more
than way to explain something. Another thing, I hope you realize that the
beginning of your response came of quite rude.


"Tom Ogilvy" wrote:

If you can't understand a well written explanation with pictures and so
forth, why do you think a better answer can be given here?

Why not go back and have another look. It isn't difficult and it would be
important to understand how it works.

If you need a sample workbook, contact me at with your
email address. Be sure to include the text of your email.

--
Regards,
Tom Ogilvy


"Crowraine" wrote in message
...
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