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.