Check out highlight actions:
I think you can do this by creating a sheet that is effectively your criteria selection interface, which will be your source sheet, and then the other sheet will be your target sheet.
Yeah, its easy with multiple sheets, but just to highlight showing two sheets will not be good and not a well use of space. Scenario is to keep the entire sheet available, but highlight what you are looking for.
If applying filter to section of the worksheet is possible, this will be doable, as you can apply the filter to a second sheet that is 'Dual axis' on the first...
You can make a source sheet as small as a quick filter. You could use a multiple sheet dashboard that looks like a single sheet with a quickfilter. This would allow you to keep the entire sheet available/visible/interactable while highlightiing what you are looking for.
I am not sure of how you would go about it without using a dashboard. I am sure there is a way with enough know-how and creativity that I do not possess .
Let me play with two sheets one with filter and practically hide it (make is small on db). Basically, if the action can be written to highlight the second sheet based on the first sheet filtered data.. cross my fingers...
Tried last night and had no luck. It looks like the only way you can use action on the dashboard is to interact with the first sheet and then make changes to the second sheet. Don;t know if there is a way without user interaction. Thanks again for your time.