Cell color is not changing through vba code

For the value CH1-E013 the color update is performed for row 47. The variable C.Row indeed holds 75 but m equals 47. The CH1-E013 value on its own is not unique!

I suggest to add the sheet value column to the key value comparison