I do see in your thread title that it says "(Not Conditional)". If it has to be VBA, I'd recommend using autofilter for this operation:
Sub FalseTrueTest2()
On Error Resume Next
Application.ScreenUpdating = False
With Range("A1", Cells(Rows.Count, "A").End(xlUp))
.AutoFilter 1, "True"
.Offset(1).Resize(.Rows.Count - 1).SpecialCells(xlCellTypeVisible).Style = "Good"
.AutoFilter 1, "False"
.Offset(1).Resize(.Rows.Count - 1).SpecialCells(xlCellTypeVisible).Style = "Bad"
.AutoFilter
End With
Application.ScreenUpdating = True
End Sub
Bookmarks