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