Hi;
I was trying to change this to cover entire columns, if T2 is " ", then A2 font would turn red. I have this for that specific cell, but would like to have this cover the entire columns to perform this action if possible?
I was trying to change this to cover entire columns, if T2 is " ", then A2 font would turn red. I have this for that specific cell, but would like to have this cover the entire columns to perform this action if possible?
Code:
Sub Pop()
If Range("T2") = "" Then
Range("A2").Font.Color = vbRed
Else
Range("A2").Font.Color = vbBlue
End If
End Sub