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
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