title: Private Sub Worksheet_Calculate()
body: <p>I can't post an image so I wanted to explain my question in more detail.</p>
  
  <p>I have 2 files: The vlookup formulas are in the Destination File. The vlookup values are in the Source File. The Destination File will be closed. The Source File will be opened. In the Source File, I may change 15 cell values. If so, I want the 15 cells in the Destination File (closed workbook) to be highlighted yellow as they contain the vlookups when I open it. I hope this explains what we're trying to solve. </p>