title: VBA Highlight Cells When Other Value is Present
body: <p>I am looking to highlight certain cells in a spreadsheet when a value is entered in a different column. I realize this can be done with conditional formatting but, due to circumstances within the company, I must use VBA. (The spreadsheet is passed onto another program that can't read conditional formatting)</p>
  
  <p>I am trying to highlight 11 different columns within my range of values whenever <strong>ANYTHING</strong> is entered into column L. For example, when a date it entered in L2, then C2, J2, K2, etc. are highlighted yellow. </p>
  
  <p>Below is what I have come up with.. unfortunately, when I run the macro, nothing happens. I see it run, but I get no results - not even an error message. Thanks in advance for the time you take to help me out!</p>
  
  <pre><code>Dim rng As Range, r As Range
  
  Set wb = ThisWorkbook
  Set sht1 = wb.Sheets("From GIS")
  Set sht2 = wb.Sheets("To MapCall")
  
  Set rng = Intersect(sht2.UsedRange, Range("L:L")).Cells
  
  
  For Each r In rng
      If r.Value = "" Then
          Cells(r.Row + 1, "C,J,K,Q,AI,AV,AW,AX,AY,AZ,BR").Interior.Color = RGB(255, 255, 0)
  
      End If
  Next r
  </code></pre>