This can be done using VBA. But what is the purpose of this and how will the value of the other cell change (would a user manually change it or does it contain a formula)?