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?
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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks