Selected Answer
You need to add a sheet to your workbook on which to keep the instructions about which columns should be highlighted for each of your 50 products. In the attached workbook that is the sheet "Products". You can use another name, but must implement that change in the code as well (I have marked the spot).
That sheet has a named range "Products" (you can change the name) which the code needs. I strongly suggest that you also use it to do data validation in your worksheets. Samples are in the worksheet "SampleSheet". However, this isn't a requirement. Only, if a product appears in the sheet which is not listed in "Products" there will be no instructions which columns to highlight.
This is the code you need to have in the codesheet of every sheet on which you wish action, all 30 of them. You can copy and paste.
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
' 13 Sep 2017
On_Change Target
End Sub
If these sheets change frequently another way can be used but that would make the workbook more difficult for you to understand.
The tab "SampleSheet" is a sample for you to test. Its name is immaterial. Note that the code expects the columns which are highlighted to have data in them. If there are blank cells removal of previous highlights will not work as expected. Other code could be found in that case once the construction of your worksheets is known.
All the code doing the actual work is in the module 'Highlights'. It is required only once. The same code works for all 30 worksheets. Please bear this in mind. If the columns aren't always the same for all sheets this approach will not be possible.