Sorting with Formatting
I misspoke here.
The colors should move with the data during a sort.
Gord
On Fri, 07 Dec 2007 14:50:59 -0800, Gord Dibben <gorddibbATshawDOTca wrote:
One method is to use Conditional Formatting on the cells' data to color them.
Then the colors will move with the cells.
Can you CF on "old stuff" and "stuff to be done" somehow?
Gord Dibben MS Excel MVP
On Fri, 7 Dec 2007 13:56:03 -0800, Patricia
wrote:
My data is color coded... black/grey is all old stuff, red is needing to be
done, etc... but when I sort by project status (not necessarly assigned to
one color) and then by project number my row colors stay put and data
moves...
How do you sort data and keep the formatting with it?
|