Okay Here is the VBA based on what you stated:

Sub HiLiRow()
For Each cl In Selection("A1:W1434")
If cl.Value = "711-Billable" Then
cl.EntireRow.Interior.Color = RGB(255, 0, 0)
End If
Next cl
End Sub


I run this as a Macro and get the error "Type Mismatch"