Setting values based on two criteria without looping

Please see attached workbook.

My goal is to set column A to "YES" if criteria is met in Column B and Column C. I am trying to accomplish this without looping. I was provided the code listed under macro "test" which works well, but only lets me set Column A based on Criteria in Column B. I am now trying to expand it so that it uses criteria from Column B and Column C.

The code that works, setting Column A to yes if "myCriteria" value exists in Column B

Please Login or Register  to view this content.

The code that doesn't work -- attempting to expand the criteria necessary to set Column A to "YES" to include a numeric set in range G2.

Please Login or Register  to view this content.

AutoFilterSample.xlsm

Not really sure what you are trying to do this time.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you, Jindon! This does the trick.