ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   autofilter colored cells (https://www.excelbanter.com/excel-programming/352927-autofilter-colored-cells.html)

chin_un_len[_10_]

autofilter colored cells
 

Hello,

The auto filter on a column will have the data on the cells and the
option to filter blanks and non blanks.
Is there a way to add a filter for background colored cells?, say RED
colored cells?

Thank you for any info given.


--
chin_un_len
------------------------------------------------------------------------
chin_un_len's Profile: http://www.excelforum.com/member.php...o&userid=30914
View this thread: http://www.excelforum.com/showthread...hreadid=510764


Ron de Bruin

autofilter colored cells
 
Hi chin_un_len

This is not a standard option in excel (in Excel 12 it is possible)

My EasyFilter Add-in can do this
http://www.rondebruin.nl/easyfilter.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"chin_un_len" wrote in message
...

Hello,

The auto filter on a column will have the data on the cells and the
option to filter blanks and non blanks.
Is there a way to add a filter for background colored cells?, say RED
colored cells?

Thank you for any info given.


--
chin_un_len
------------------------------------------------------------------------
chin_un_len's Profile: http://www.excelforum.com/member.php...o&userid=30914
View this thread: http://www.excelforum.com/showthread...hreadid=510764




chin_un_len[_11_]

autofilter colored cells
 

Hello Ron de Bruin,

Thank you for your help, I will sure give easyfilter a try.

Much Appreciated.


--
chin_un_len
------------------------------------------------------------------------
chin_un_len's Profile: http://www.excelforum.com/member.php...o&userid=30914
View this thread: http://www.excelforum.com/showthread...hreadid=510764



All times are GMT +1. The time now is 05:01 PM.

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