title: VBA - Conditional Format (Font Size)
body: <p><strong>Purpose:</strong> Conditional Formatting - Font Size </p>
  
  <p>If K19 = "Downpayment Source:" Then  K19 font 10, else 12</p>
  
  <p>If K21 = "Amount:" Then K21 font 10, else 12.</p>
  
  <p><strong>Trying:</strong></p>
  
  <p><div class="snippet" data-lang="js" data-hide="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>Option Explicit
  
  Private Sub Worksheet_Change(ByVal Target As Range)
  
  Set Target = ActiveSheet.Range("K19")
  
  
  If Target = "Downpayment Source:" Then
  With ActiveSheet.Range("K19").Font
  .Name = "Arial"
  .Size = 10
  End With
  Else
  With ActiveSheet.Range("K19").Font
  .Name = "Arial"
  .Size = 12
  End With
  Exit Sub
  
  
  End Sub</code></pre>
  </div>
  </div>
  </p>
  
  <p>This code works, but I don't know how to add K21.</p>
  
  <p><strong>Another Idea:</strong></p>
  
  <p>If B3="Purchase" then K19, K21 font size 10, else 12.</p>
  
  <p>Either one would work, I'm just not that experienced with VBA.</p>
  
  <p>Any help is greatly appreciated</p>