| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel List & Format
Greetings and Thanks in Advance!
I have a list which I have formatted using AutoFormat List 1, but when I sort some of the shaded rows are next to one another instead of alternately. How can I make the alternate shading stay after sorting? Thanks again. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel List & Format
You can use Conditional Formatting to do this. See
www.cpearson.com/excel/banding.htm -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Excel User" wrote in message ... Greetings and Thanks in Advance! I have a list which I have formatted using AutoFormat List 1, but when I sort some of the shaded rows are next to one another instead of alternately. How can I make the alternate shading stay after sorting? Thanks again. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the format in a excel drop box? | Excel Discussion (Misc queries) | |||
| date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
| EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
| I cannot get time format to display in a drop-down list | Excel Discussion (Misc queries) | |||
Linear Mode
