Can i search for cells of a particular color

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter rows data based on background color of individual cells 1
Condtional Formatting, Cell Upon Cell 3
SUMCOLOR with conditional formatting not working 3
Counting the number of rows based on the color 2
Conditional format color change 2
Search and then format by color 1
Conditional Formatting 3
Conditional Formatting Based on Colors in a Horz Range of Cells 10

Top