| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Color Palette, color disappears | Excel Discussion (Misc queries) | |||
| Edit Color Palette Names | Excel Discussion (Misc queries) | |||
| How do I reset my color palette in Excel? | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
Linear Mode
