| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Rows By Colors
Can you sort rows of different colors in categories by formula or macro?
Or Can you make up a formula or macro like: if cell A1 is filled with red color the result is "R" otherwise "G". |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Rows By Colors
Check this out
http://www.xldynamic.com/source/xld.ColourCounter.html -- -- -John Please rate when your question is answered to help us and others know what is helpful. "FARAZ QURESHI" wrote in message ... Can you sort rows of different colors in categories by formula or macro? Or Can you make up a formula or macro like: if cell A1 is filled with red color the result is "R" otherwise "G". |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Rows By Colors
Or, you can try this site by Pearson Sowtware Consulting Services:
http://www.cpearson.com/excel/SortByColor.htm -- T Tipsy "John Bundy" wrote: Check this out http://www.xldynamic.com/source/xld.ColourCounter.html -- -- -John Please rate when your question is answered to help us and others know what is helpful. "FARAZ QURESHI" wrote in message ... Can you sort rows of different colors in categories by formula or macro? Or Can you make up a formula or macro like: if cell A1 is filled with red color the result is "R" otherwise "G". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting a sheet with outlined rows | Excel Discussion (Misc queries) | |||
| sorting rows | Excel Worksheet Functions | |||
| Sorting with Multiple Rows per Entry | Excel Worksheet Functions | |||
| How do i keep the colors applied to the specific rows when sor | Excel Discussion (Misc queries) | |||
| Alternating colors for rows | Excel Discussion (Misc queries) | |||
Linear Mode
