title: Selecting two columns based on active cell?
body: <p>I'm trying to do conditional formatting on a long range of columns in groups of 2. Im not sure how record a macro that would select the entire column from the active cell and the column next to it, then apply the conditional formating. Then move two cells down and repeat. </p>
  
  <p>This is what I have so far but it would keep going back to those specific cells, I need it to move to the right 2. </p>
  
  <pre><code>Sub findDups()
  '
  ' findDups Macro
  
      ActiveCell.EntireColumn.Select
  
      Selection.FormatConditions.AddUniqueValues
      Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
      Selection.FormatConditions(1).DupeUnique = xlDuplicate
      With Selection.FormatConditions(1).Font
          .Color = -16383844
          .TintAndShade = 0
      End With
      With Selection.FormatConditions(1).Interior
          .PatternColorIndex = xlAutomatic
          .Color = 13551615
          .TintAndShade = 0
      End With
      Selection.FormatConditions(1).StopIfTrue = False
      Range("M1").Select
  
      Worksheets("User Check List").Activate
      Selection.Offset(0, 2).Select
  End Sub
  </code></pre>