Hi buljky003

Welcome to the forum.

You seem to have already worked out the best solution. The solution depends on how the data from the web is laid out in your spreadsheet. The easiest would be if your data occupied columns A - G with G being one with the data to be highlighted. Life is not as easy as that, so if you could upload a sample (ensure all sensitive data removed) we can see how best to solve this.

Regards
Alastair