VBA to filter source column by search field input and/or conditional formatted cell color

[drewship]

Hill all. I need to use VBA to filter source column by search field input and/or conditional formatted cell color. Thanks to DBY here

for helping get the Search cell working, but I think to get the optimal results, VBA will be required to use the search cell as needed and I have no clue how to achieve this. There will be over 500 cells in column 'A' that contain text, hyperlinks to their respective sheets, and conditional formatting to color the cells red, yellow, or green based on the results of the respective sheet cells 'C1:C3'. Any help is appreciated.

Andrew

[drewship]

I just tried to record a macro to do what I need

Please Login or Register  to view this content.

but the result was that "ri" provided 2 records, the autofilter for the 'red' cells displayed the 3 red cells in the column instead of the one that matched 'ri' and was red, so possibly ANDing them together somehow would work.

[drewship]

Found

which explains VBA autofolter but since Criteria1 is an variable text input and Criteria2 is a variable cell color input, I have no clue how to implement it, if it is even possible using this example. I think if I can have a search cell for the user to enter some text and some colored cells for the user to select the desired color to search for, those variables would be saved in Criteria1 and Criteria2 for the code to use.

[drewship]

Anyone have the knowledge to do this?