ExcelBanter - sort sheet by text color

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sort sheet by text color (https://www.excelbanter.com/excel-discussion-misc-queries/147123-sort-sheet-text-color.html)

sort sheet by text color

does anyone know how I can sort a sheet by a cell's formatting (ie. color)

Chip Pearson

sort sheet by text color

See the "Sorting By Color" page on my web site:
http://www.cpearson.com/excel/sortbycolor.htm

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"gb" wrote in message
...
does anyone know how I can sort a sheet by a cell's formatting (ie. color)

All times are GMT +1. The time now is 01:43 PM.