Forum Discussion
Filtering cell range/table based on selected value in a drop-down list
Hi, I have a range of cells/table in excel that I would like to filter based on a selected value (from a drop down list that is not a part of the table). So, it is like filtering multiple columns a...
The FILTER function will enable doing what you're asking about. Not sure that you can do it based on color, but if the color itself is a result of conditional formatting (and if it isn't, it should be), then just use the basis for that conditional formatting.
Here's a link to a site that explains FILTER.
Here's a video that helps understand FILTER along with a few other "dynamic array" functions.
If you want more help, perhaps you'd be willing to post a copy of your workbook on OneDrive or GoogleDrive with a link here that grants access.