look for value in another cell and change current cell if true

[rharri1972]

I really don't know if my thread title is confusing but i will try to explain what i am trying to accomplish.
Any help will be GREATLY appreciated!!!

I have a worksheet("REPORT")
When completed it is Subtotaled with each change in PRODUCT ID which is column E and the subtotal is listed in MRP QTY which is Column H.
So the line Product ID (whatever the product may be) Total is Bold but the subtotal is not.

Is there a way with vba to make the subtotal cell (column H) to look left to Column E and if that cell in same row includes the word Total to make the subtotal cell (in Column H )value change to bold?

 

[Peter_SSs]

Duplicate to: how to make each cell with subtotal in it to be bold with vba

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread since the other one has replies so please continue in the linked thread.