Can i search for cells of a particular color

A

Ashutosh

I want to find cells which are colored in a particular color.
Like if there are yellow and green colored cells, spread across the sheet,
and I want to search only for green cells, can I do that?

Also can I sort the cells based on a particular cell color, so that all
green cells appear before all the yellow cells.

Thanks,
Ashutosh
 
N

Niek Otten

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I want to find cells which are colored in a particular color.
| Like if there are yellow and green colored cells, spread across the sheet,
| and I want to search only for green cells, can I do that?
|
| Also can I sort the cells based on a particular cell color, so that all
| green cells appear before all the yellow cells.
|
| Thanks,
| Ashutosh
 
Top