Re : Sorting columns by text colour

[melvinc74]

Dear All,

Is it possible to sort data in column by colour of text,if yes how ??

 

[Frank Kabel]

Hi
one way:
- create a helper column
- Use the UDF Colorindex from Bob Phillips/Harlan Grove which can be
found in the following thread: http://tinyurl.com/2u22g
- in your helper column add the formula =Colorindex(A1)
- copy this down

Now you can sort with this helper column

 

[Gord Dibben]

mel

How did the text get colored? By Conditional Formatting or manually?

If by CF, you may be able to sort based on the conditions.

If not, you must use VBA.

See Chip Pearson's site for SortByColor VBA code.

http://www.cpearson.com/excel/SortByColor.htm

Gord Dibben Excel MVP