I'm trying to create a macro
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..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
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!
Last edited by grey; 01-31-2012 at 06:25 AM.
Have you tried changing the H2 to A2?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks