Re : Sorting columns by text colour

  • Thread starter Thread starter melvinc74
  • Start date Start date
M

melvinc74

Dear All,

Is it possible to sort data in column by colour of text,if yes how ??
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Formatting 3
Gray Out Expired Records 5
Excel Colour code dates 1
Conditional format based on a different column 2
Collapsing all groups 0
Sorting by text colour 1
sorting with custom data 1
Text Colour 5

Back
Top