Hi All,

Is there a way to filter columns by both color and text? Some rows have
color some rows have text (Y/N). And I need to filter out all the gray cells
and the cells with "Y"

regards

Reginald

Hi Reginald,

Yes, you can definitely filter columns by both color and text in Excel. Here are the steps:

1. Select the column that you want to filter.
2. Click on the "Filter" button in the "Data" tab.
3. Click on the drop-down arrow in the column header and select "Filter by Color".
4. Choose the color that you want to filter out (in this case, gray).
5. Click on the drop-down arrow in the column header again and select "Text Filters".
6. Choose "Does Not Equal" and enter "Y" in the text box.
7. Click "OK" to apply the filter.

This will filter out all the gray cells and the cells with "Y" in the selected column. You can then copy and paste the filtered data to a new sheet or work with it as needed.

Hi,

The trick to doing this is to create a second column which refers to the Y,
N and then apply the filter using both columns:

Suppose your Y/N color column is A1:A100 with titles on the first row, in B1
enter "Dummy" and in B2 enter
=A2
Copy this down.
Apply the filter to both columns. From the column A filter pick Color is
Gray. From the column B filter pick Y.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Regalibar" wrote:

Hi All,

Is there a way to filter columns by both color and text? Some rows have
color some rows have text (Y/N). And I need to filter out all the gray cells
and the cells with "Y"

regards

Reginald

Well, you can achieve this task using macro
Add a command button on the sheet from the control box and paste following codes in codes window


Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com