I got a list with thousands of rows with the following make-up. For example
Column A Column B
90-234-58-75 Product A
90-234-58-59 Product B
I would like to apply shading to these rows in an orderly/uniform manner using a VBA macro so that ...
... rows with the product numbers get a red shading ...
... the rows featuring the quantity get a grey shading
... the rows featuring the marking get a dark grey shading
I have attached a sample file with details for your convenience.
Thank you very much for your great help.