ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   can you select rows in excel with a certain background color? (https://www.excelbanter.com/excel-worksheet-functions/38526-can-you-select-rows-excel-certain-background-color.html)

stelee

can you select rows in excel with a certain background color?
 
I want to know if there is a way of selecting all rows in a spreadsheet that
have a specific background color. e.g. all rows in yellow

Ron de Bruin

Hi

Maybe you can use this (not working if you use Conditional Formatting)
EasyFilter Beta 2.1 can filter on colors (bottom of the page)
http://www.rondebruin.nl/easyfilter.htm


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


"stelee" wrote in message ...
I want to know if there is a way of selecting all rows in a spreadsheet that
have a specific background color. e.g. all rows in yellow





All times are GMT +1. The time now is 06:19 AM.

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