Search on color of text

[mobile]

hello,

I have a spreadsheet filled with about 200 line entries, I would like to
create a report or another spreadsheet based on a search of color of text. I
color code the text of a row, to a certain color and would like to pick
those specific colors out of the sheet and copy them to a new sheet to
analyze some data.

thanks

 

[Gord Dibben]

Excel cannot search on text or background color unless assisted by VBA coding.

See Chip Pearson's site for methods.

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

Or Bob Phillips' site.

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


Gord Dibben MS Excel MVP

 

[Dave Peterson]

You may want to look at the way Ron de Bruin approached it:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm