title: Change font color to black when cell is activated
body: <p>I have a cell formatted with red font. I'd like for the format to change to black font when the user clicks on the cell, or navigates to it with the keyboard.</p>
  
  <p>The cell is "Q15". I'd like the code to apply to all instances of "Q15" within the workbook--regardless of which sheet.</p>
  
  <p>I have entered the following in "ThisWorkbook". How do I specify that I am referring to "Q15" in all worksheets?</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target as Range) 
      Target.Font.ColorIndex = 1
  End Sub
  </code></pre>