Can i search for cells of a particular color
 

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

Can i search for cells of a particular color
 

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ashutosh" <Ashutosh @discussions.microsoft.com wrote in message ...
|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