title: Applying dynamic formatting in Excel on multiple tables on the same sheet
body: <p>I use an Excel document to track cryptocurrencies and I have multiple tables on the same sheet. I'm looking for the VBA code that would format the cells based on the input in another cell. </p>
  
  <p>Currently I'm formatting based on another cell with the below code. Example of what I'm trying to achieve: <a href="http://prntscr.com/p3sof8" rel="nofollow noreferrer">http://prntscr.com/p3sof8</a></p>
  
  <p>Code:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      With Target
          If .Count = 1 Then
              If .Column = 1 Then
                  If .Value &lt;&gt; "BTC" Then
                      .Offset(, 1).NumberFormat = "0.00000000" &amp; """ " &amp; .Value &amp; """"
                  Else
                      .Offset(, 1).NumberFormat = """" &amp; ChrW(&amp;HE3F) &amp; """" &amp; "0.00000000"
                  End If
              End If
          End If
      End With
  End Sub
  </code></pre>
  
  <p>This works perfectly for one sheet.</p>
  
  <p>What I'm looking for is to use this kind of a code for multiple tables on the same sheet, that have different offsets, "defining" columns etc.</p>
  
  <p>For example, on Table1, the currency is inputed in column A, and formatted cell is in column B. On Table2, the input column is C and results are in E and F, etc.</p>
  
  <p>Can the above code be altered in a way that I could use it for different tables on a single sheet?</p>
  
  <p>Thank you very much for your insights!</p>