Conditional Formatting in table using the column names in the Formula

[SA_Carpenter]

Hello,

Hopefully someone can help

I am trying to highlight the values in one "Amdt x" whenever it differs from the value in "Current Amdt". Originally I called out the column letter, but as the table changes and gets updated I want to use the column names to avoid having to rework the macro every time.

My table looks something like

and the code I was using before is

ActiveSheet.ListObjects("Table1").ListColumns("Amdt x").Range.Select
        Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=$D2<>$E2"
        Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
        With Selection.FormatConditions(1).Interior
                    .PatternColorIndex = xlAutomatic
                    .Color = 6053086
                    .TintAndShade = 0

Essentially I wanna replace $D2 with Amdt x and $E2 with Current Amdt. Hopefully I explained this well enough and any help would be appreciated

 

[6StringJazzer]

Conditional formatting formulas cannot include structured table references.