Hi All,
I'll be sending out a template to co-workers and I was wondering if there would be anyway to highlight if data that I'm sending out is altered when they send it back to me?
I was hoping conditional formatting could help but I havent been able to find the anwer through that so I was hoping you all might have ideas.
Thanks!!!
Only way I know of is to have a copy of the data somewhere else to compare to. If you don't want to bother with a separate copy of the data, create a hidden sheet in the template that has the original data in it along with validation that compares its values to the data in the live template. Any altered values can "highlight" on the hidden sheet.
All you would need to do is unhide the sheet and see what's lit up.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
you could turn on track changes, but they could turn it back off.but if you turn off highlight changes they wouldnt know, you could turn it back on when you get it back
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks