• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Highlight the cell when the cell value is changed by anyone

J

Jagdev Singh

Active Member
Hi Experts

I am looking for a VBA code which will highlight the cell when its value is changed by someone. It would be great if it is highlighted in red.

Also, the column of these cells has formula in it. In short the value of the cells are calculated by the Formula.

Please find the sample file attached with the mail. In case if someone change the "Review Status" in any cell. The particular cell should get highlight to red.

Regards,
Jaggi
 

Attachments

Last edited:
Hi Jagdev,
What do you mean by changed by someone?
Is there any fixed criteria ?

As i didn't get your actual requirement, i just copy past current value of column g to column h.
and than applied simple conditional format formula:
=G2<>H2

I have attached the file shows working.
try changing values of column D

Regards,
 

Attachments

Hi Jaggi ,

If really speaking the cells have a formula , then you should ensure that no one can change them , rather than allowing users to change them , and then flagging the change.

If you use the Worksheet_Change event procedure , you can detect changes and undo them.

Narayan
 
Hi Narayan

When I try to change anything in column G it throws an error. Please find the screen-shot attached.

Regards,
Jaggi
 

Attachments

  • Capture.PNG
    Capture.PNG
    7.5 KB · Views: 2
  • Capture1.PNG
    Capture1.PNG
    8.4 KB · Views: 2
Khalid NGO said:
Hi Jagdev,
What do you mean by changed by someone?
Is there any fixed criteria ?

As i didn't get your actual requirement, i just copy past current value of column g to column h.
and than applied simple conditional format formula:
=G2<>H2

I have attached the file shows working.
try changing values of column D

Regards,
Click to expand...

Hi Kalid

Thanks for your feedback..Could you please lemme know how did you hide the values in column H. I am curious to learn this concept..

The criteria is such that if any user bymistakenly or intensionally change any value in column G. The cell should get highlighted to lemme know that the value of the cell is changed by the user.

Regards,
Jaggi
 
Hi Narayan

Thanks for the solution. It is working fine when we are dealing with core excel sheet. Is it possible to make it work with Pivot table.

Let me clear it further. Say the exact value is in pivot and I have added one column at the end of the pivot table which will work as an excel column. I am adding formula in that column ( the way I did on column G).

Is it possible to amend the code in such scenerio and make it work in the way it is working now.

Regards,
Jaggi
 
Hi Narayan

Please find the Sample file attached. Check the Pivot tab and specially "M" column

Also, please try to keep the condition dynamic. The data count may vary in future..

Regards,
Jagdev
 

Attachments

You must log in or register to reply here.
Back
Top