Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Quick way to sort lists by text color?
Ok, some genious sent me a spreadsheet with thousands of rows that I need to extract and sort out all text that is red. Is there a way to sort to maybe do an if/then formula in an additional column to input some text to do a quick sort on that? -- PokerZan ------------------------------------------------------------------------ PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480 View this thread: http://www.excelforum.com/showthread...hreadid=376116 |
#2
|
|||
|
|||
Take a look he
http://cpearson.com/excel/SortByColor.htm In article , PokerZan wrote: Ok, some genious sent me a spreadsheet with thousands of rows that I need to extract and sort out all text that is red. Is there a way to sort to maybe do an if/then formula in an additional column to input some text to do a quick sort on that? |
#3
|
|||
|
|||
Thank you, but I am not sorting by cell color but color of text. -- PokerZan ------------------------------------------------------------------------ PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480 View this thread: http://www.excelforum.com/showthread...hreadid=376116 |
#4
|
|||
|
|||
Did you read all the page?
Using Chip's Functions you can sort by cell color OR by font color. Have another look at the part that states........ If you want to sort by the Font color of the cell, use the formula =ColorIndexOfCell(A1,TRUE,TRUE) Gord Dibben Excel MVP On Thu, 2 Jun 2005 17:29:35 -0500, PokerZan wrote: Thank you, but I am not sorting by cell color but color of text. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set my color default for gridlines & text? | Setting up and Configuration of Excel | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Excel should allow me to change text color & font within tabs. | Excel Discussion (Misc queries) | |||
Format text based on which of several unique lists the value belongs to? | Excel Worksheet Functions | |||
Can you sort text in a column, but leave cell color alone? | New Users to Excel |