Highlight the values of a column which are list based on another column values in a sheet

[Saritha123]

I have two sheets Pricing and Product_Discount as attached.
Pricing sheet data will start from Row5 and Product_Discount data will start from row 7.
Column 'P' from the Pricing sheet should be a list from Column 'D' of Product_Discount sheet.(these values are dynamic may increase or decrease).

In pricing sheet based on the Column Q value, if that value exists in E column of Product_Discount sheet, then respective value from the list in column 'P' of Pricing sheet should get highlight/select automatically.

Example:
If column 'Q' of Pricing sheet has a value -167%, then column 'P' of Pricing sheet should select 'Prod_Disc' (as Product_Discount sheet has a value Prod_Disc for -167).

Please help in a VBA macro.
Attached the sample excel.