Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
don't move formats on sort
i have a sheet where every other line is shaded. i want to sort the data but
maintain the every other line shaded format. is there a way to do this without writing a macro to redo the formating every time i sort? thanks in advance for your time. dkingston |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
don't move formats on sort
You should use Conditional Formatting to shade the cells. See
www.cpearson.com/excel/banding.htm for more details and formulas. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "dkingston" wrote in message ... i have a sheet where every other line is shaded. i want to sort the data but maintain the every other line shaded format. is there a way to do this without writing a macro to redo the formating every time i sort? thanks in advance for your time. dkingston |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
don't move formats on sort
Shading should be based on conditional formatting with formula:
=MOD(ROW();2)=0 HTH -- AP "dkingston" a écrit dans le message de news: ... i have a sheet where every other line is shaded. i want to sort the data but maintain the every other line shaded format. is there a way to do this without writing a macro to redo the formating every time i sort? thanks in advance for your time. dkingston |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
don't move formats on sort
thanks much guys, the conditional formatting worked like a charm.
"dkingston" wrote: i have a sheet where every other line is shaded. i want to sort the data but maintain the every other line shaded format. is there a way to do this without writing a macro to redo the formating every time i sort? thanks in advance for your time. dkingston |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I format a column in alpha order? | New Users to Excel | |||
Blank Spaces on Sort | Excel Discussion (Misc queries) | |||
How can I sort multiple times | Excel Worksheet Functions | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) |