Highlighting Rows

N

Nan

I have a spreadsheet where every other line is highlighted (for ease o
reading). When I sort the data, the colors also change position so I n
longer have every other line highlighted.

Is there a way to prevent this from happening? I would like th
highlights to remain fixed but have the data in the cells sort based o
my criteria. So, if row 1 is highlighted green, I would like it t
remain green even if the data in that row changes.

I hope I'm being clear.

Thanks for any help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top