This code works great to change the cell colors when importing the data. I'm looking to make it dynamic so that if the value in cell(50, i) is changed the code will rerun. I know you can use the worksheet change code in the Sheet, but these sheets aren't existing, they are added when code is run. I'm also looking to make the color in cells(61,i) and (62,i) the same color as cell(63,i).
Dim i As Long For i = 2 To LastColumn If .Cells(63, i) >= 1 And Not IsEmpty(Cells(63, i)) Then .Cells(63, i).Interior.Color = 13434828 ElseIf .Cells(63, i) < 0 And Not IsEmpty(Cells(63, i)) Then .Cells(63, i).Interior.Color = 255 End If Next i