• 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 Rows with Check Box

vijay.vizzu

vijay.vizzu

Member
Dear all


I have one PO Summary file which i have to mail to my group members around 25. They requsted to me to highlight changes made on that day. So i have to do this by manually daily. so it irritates me. So i want to put a check box, if the group members wants to watch the changes made by me, then they can click on that check box, then the rows will be hightlighted which are changed on that day. So have you any idea to resolve this.

Not to be VBA code.


Thanks in advance
 
Hi,


One possible solution would be to use Excel's built in track changes function.


In Excel 2007 this is on the review tab on the Ribbon.


HTH
 
I think any other solution would have to involve VBA (date stamping a helper cell via a cell change event would probably be the best VBA solution)
 
You must log in or register to reply here.
Back
Top