Hi,
How can I alter this line of code to not only change the cell to red but have white letter font
![]()
For i = lastRow To 1 Step -1 If Range("B" & i).Value = "NA" Then Range("B" & i).Interior.ColorIndex = 3
Hi,
How can I alter this line of code to not only change the cell to red but have white letter font
![]()
For i = lastRow To 1 Step -1 If Range("B" & i).Value = "NA" Then Range("B" & i).Interior.ColorIndex = 3
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks