ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I filter cells by color? (https://www.excelbanter.com/excel-discussion-misc-queries/87960-can-i-filter-cells-color.html)

Naum

Can I filter cells by color?
 
When filter is set to Auto I would like to request, say, all cells with red
background. Or all cells with data in red font. These options should be
included in the filter drop-down along with All, Custom, etc. I assume that
does not exist now. How can I deliver my request to Excel Development Group?

Thanks

Bob Phillips

Can I filter cells by color?
 
No need, Ron de Bruin has already done it. See
http://www.rondebruin.nl/easyfilter.htm

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Naum" wrote in message
...
When filter is set to Auto I would like to request, say, all cells with

red
background. Or all cells with data in red font. These options should be
included in the filter drop-down along with All, Custom, etc. I assume

that
does not exist now. How can I deliver my request to Excel Development

Group?

Thanks





All times are GMT +1. The time now is 09:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com