View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ashutosh Ashutosh is offline
external usenet poster
 
Posts: 1
Default 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