Look he

http://xldynamic.com/source/xld.ColourCounter.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"MACXXXX" wrote in message ...
| Is it possible to sort by cell color format or text color format? I tried to
| gather info by CELL but it always returns G .