Note, however, that changing the formats in the source range will not
trigger a Change event, so the destination cell won't change until a new
entry is made in the source range...

In article ,
JE McGimpsey wrote:

Put this in your worksheet code module (right-click on the worksheet tab
and choose View Code):