Highlight rows multiple criteria vba

[realrookie]

Hello,

Looking for a code that highlights rows when criteria are met (or not) via a InputBox.

e.g.: run macro, input box 1: enter premium, input box 2: enter selected. Run throw the rows and every row that has "premium" and "selected" higlights green, but if there is only 1 of the criteria in the row, highlight red.

Attached is sample of the expected result.


I tried changing the following code as it highlights cells but no luck.

Please Login or Register  to view this content.

Any help appreciated.

Red

[6StringJazzer]

This code is a bit more straightforward, and it works. You will need to add code to accumulate the counts, if you need counts. You can also add error messages, if you want.

Please Login or Register  to view this content.

[realrookie]

Hello sir,
thank you for the reply. Indeed it works on the sample sheet, but my mistake. I should have mentioned that the search of the Inputbox is not limited to a specific column, as this changes from client to client.
After adding the code to live data, nothing actually happens (even after I changed the columns).

Would it be dependent on case sensitive and hidden columns?

Sample sheet with live cleaned data attached.

[JOHN H. DAVIS]

Another:

Please Login or Register  to view this content.

[realrookie]

Mr Davis,

Wonderful as always. But this runs to good. It does what I ask, but when I added it to the live data, i got more results then I expected. Live data has around 28k rows of products and up to Column AP.

Is there a way, so that I can tell it in which column to search first for Criteria 1, and based on those results it would search the rest of the row (where criteria 1 was found) for criteria 2.