Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill colors and sorting
I have a spreadsheet that has certain rows highlighted to denote status.
When I add information and re-sort to alphabetize the colors do not move with the data. Can you help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill colors and sorting
Hi,
For your cells to keep their formats, take a look at Format Conditionnal formatting ... HTH Cheers Carim |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill colors and sorting
Conditionally formatted colors do not sort with the data.
However, normal color formatting does sort with the data. Borders of any type never sort with the data. -- Jim Cone San Francisco, USA http://www.officeletter.com/blink/specialsort.html "Durrer Floors" wrote in message I have a spreadsheet that has certain rows highlighted to denote status. When I add information and re-sort to alphabetize the colors do not move with the data. Can you help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
colors of bar charted data don't follow data after sorting | Charts and Charting in Excel | |||
Sorting by Colors | Excel Discussion (Misc queries) | |||
Sorting Cells by Colors | Excel Discussion (Misc queries) | |||
Sorting by colors | Excel Discussion (Misc queries) | |||
Colors of columns after sorting data in the supporting table | Charts and Charting in Excel |