Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to sort list, bolded items from no bolded?
I'm wondering how to sort a list that has some items bolded and some not.
I need to know how to sort bolded items from non-bolded for a chart or table comparison. Customers that inquired about services are all listed. Then if the customers funds/buys a service, we bold their name, etc. I want to know how to sort for comparison sake. Thank you for any information. |
#2
|
|||
|
|||
Formatting (bold, color, etc.) should not be used to store information. It
should be used for presentation only. Excel isn't set up to operate on it. It can be done with macros, if you want to do it that way. Read "Formatting as data" at http://www.smokeylake.com/excel/excel_truths.htm -- Earl Kiosterud www.smokeylake.com/ ------------------------------------------- "tcd50" wrote in message ... I'm wondering how to sort a list that has some items bolded and some not. I need to know how to sort bolded items from non-bolded for a chart or table comparison. Customers that inquired about services are all listed. Then if the customers funds/buys a service, we bold their name, etc. I want to know how to sort for comparison sake. Thank you for any information. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort a Subtotalled List? | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Is it possible to sort a list by type face? ie. all the bolded li. | Excel Discussion (Misc queries) | |||
Items in a List | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) |