Notification of an edit

[chickadeejen]

Hi,

Here's the layout:
Col A (notification of an edit been made within the range of col B to Z - alert)
Col B to Z has data in each col.

I think this should be easy for you experts out there! I just need an alert in Col A, which highlights if anyone has made a change within the row from A - Z. The alert can be last edited date or a colour showing a change within the last 7 days.

Can this be done?
Thanks
Jen

 

[VoG]

What about Tools > Track Changes?

 

[chickadeejen]

True - I'm working in excel 2007 - do they have this option?

 

[VoG]

Try Changes on the Review tab.

 

[chickadeejen]

You're right! Thanks this should work!