ChatterBank1 min ago
Excel help needed
1 Answers
Is it possible to sort or filter a spreadsheet by font colour?
Answers
Best Answer
No best answer has yet been selected by matt_london. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.Possible, yes, but it's not built-in. You'll have to write some VBA code - have a look at
http://www.ozgrid.com/VBA/Sort.htm
- or go to Google and search for "sort excel by color" - there's plenty of people who have written similar pieces of code.
http://www.ozgrid.com/VBA/Sort.htm
- or go to Google and search for "sort excel by color" - there's plenty of people who have written similar pieces of code.