LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
PokerZan
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set my color default for gridlines & text? Excel default grid colors Setting up and Configuration of Excel 1 April 11th 05 10:24 PM
Sort or Filter option? Mcobra41 Excel Worksheet Functions 3 February 23rd 05 07:22 PM
Excel should allow me to change text color & font within tabs. hw Excel Discussion (Misc queries) 1 February 17th 05 10:52 PM
Format text based on which of several unique lists the value belongs to? [email protected] Excel Worksheet Functions 2 December 13th 04 11:23 PM
Can you sort text in a column, but leave cell color alone? g wills New Users to Excel 4 December 3rd 04 10:42 AM


All times are GMT +1. The time now is 06:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"