How to check if a cell is colored?

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.

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

--

HTH

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


"prampuria" <[email protected]> wrote in message
news:[email protected]...
> 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.
>

Hi Prampuria,

See Chip Pearson's page on sorting by colour.

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


---
Regards,
Norman



"prampuria" <[email protected]> wrote in message
news:[email protected]...
>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.
>