How to check if a cell is colored?

[prampuria]

I have an array, of which some cells are colored. I want to learn how
to do following:
1. To sort by color
2. To bring all the colored content into another worksheet.

I have tried using cell(info_txt, reference) function but to no avail.


Thanks in Advance.
Piyush.

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.ColourCounter.html for some
techniques

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Norman Jones]

Hi Prampuria,

See Chip Pearson's page on sorting by colour.

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