Cell color is not changing through vba code

The jpg will not help anyone. Its better if you attach a sample file with the code.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

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

Ramana,

I think it is because it finds the value it is looking for on an earlier row, i.e. the value you are searching for is not unique as it occurs on multiple worksheets.