ExcelBanter - Background stays when sorting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Background stays when sorting (https://www.excelbanter.com/excel-discussion-misc-queries/259228-background-stays-when-sorting.html)

Hunter

Background stays when sorting

Is there anyone to set a background color that doesn't change when sorting?
I have an excel spreadsheet that has different colors every other row. When
I sort, the colored rows move too. How can I get them to stay in place and
only sort the values?

Bob I

Background stays when sorting

In 2007 you can Format as Table. Or you could use conditional formatting
based on row.

hunter wrote:
Is there anyone to set a background color that doesn't change when sorting?
I have an excel spreadsheet that has different colors every other row. When
I sort, the colored rows move too. How can I get them to stay in place and
only sort the values?

Gord Dibben

Background stays when sorting

Use Conditional formattingFormula is:

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0

This will survive through sorting and filtering.

Gord Dibben MS Excel MVP

On Thu, 18 Mar 2010 06:26:02 -0700, hunter
wrote:

Is there anyone to set a background color that doesn't change when sorting?
I have an excel spreadsheet that has different colors every other row. When
I sort, the colored rows move too. How can I get them to stay in place and
only sort the values?

All times are GMT +1. The time now is 05:17 PM.