I'm trying to create a macro
Sheets("List").Range("A2:L" & LastRow).FormatConditions.Delete
Sheets("List").Range("A2:L" & LastRow).FormatConditions.Add Type:=xlExpression, Formula1:= _
"=AND($G2<>"""",H2="""")"
Selection.FormatConditions(1).Interior.ColorIndex = 38
I know this is probably really simple, but I'm getting stuck on how to make that H2 so that it's a dynamic reference to the cell in question..
So if this conditional formatting was applied to H2, it would be correct, if it was applied to H3, that should say H3 and so on.
Can anyone tell me where I'm going wrong?
Thanks!
Bookmarks