| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sorting information on a template.
I have a chart that alternates colors for every row. How can I save the
template for this worksheet so that the colors don't leave their rows when I sort the data? |
|
#2
|
|||
|
|||
|
Instead of colouring the rows, you can use conditional formatting. Chip
Pearson has instructions: http://www.cpearson.com/excel/banding.htm Wendy wrote: I have a chart that alternates colors for every row. How can I save the template for this worksheet so that the colors don't leave their rows when I sort the data? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need One Excel Template to copy to TWO Databases | Excel Discussion (Misc queries) | |||
| A template for financial information | Excel Discussion (Misc queries) | |||
| sorting two columns' information | Excel Discussion (Misc queries) | |||
| Excel as a database and sorting information | Excel Discussion (Misc queries) | |||
| How do I find a template to record client information? | Excel Discussion (Misc queries) | |||
Linear Mode
