| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| new installation but old license name stays!!! | Excel Discussion (Misc queries) | |||
| Name stays, everything else scrollable. | Excel Discussion (Misc queries) | |||
| One column stays while others scroll | Excel Discussion (Misc queries) | |||
| FIX TOP ROW,SO WHEN I SCROLL DOWN IT STAYS AT TOP | Excel Discussion (Misc queries) | |||
| Sorting data while the shading stays the same | Excel Worksheet Functions | |||
Threaded Mode
