How do I write below where I can change N2 or X2

[cogswel__cogs]

I can use VBA to create conditional formatting where cells is highlighted yellow if range in column N does not equal column x
But as my program wants might want to change n2 or x2.

Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=N2<>X2"

How can I write this where I have flexibility to change the column. The" " throw me off nd I can't seem to make it work not hard coded.
So say I had a string value vl with a value of "E"

I'd like to say
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= & vl & "2<>X2"

any help is appreciated.

 

[rlv01]

Try this.

vl = "E"
Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=" & vl & "2<>X2"

 

[cogswel__cogs]

Worked perfectly many thanks.

 

[rlv01]

Glad I could help.