ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I filter on rows that are shaded in a different color? (https://www.excelbanter.com/excel-worksheet-functions/134721-how-can-i-filter-rows-shaded-different-color.html)

Frank

How can I filter on rows that are shaded in a different color?
 
How can I filter on rows that are shaded in a different color?

Ron de Bruin

How can I filter on rows that are shaded in a different color?
 
Hi Frank

In Excel 2007 this is possible but not built-in in older versions.

You can use my add-in if you want
http://www.rondebruin.nl/easyfilter.htm

Or see
http://www.cpearson.com/excel/colors.htm
And
http://www.xldynamic.com/source/xld.ColourCounter.html


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Frank" wrote in message ...
How can I filter on rows that are shaded in a different color?



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

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