How to set red colour to complete row text when column "Results" contains failed?

yes but its troublesome, if you want to highlight whole row, do this instead

  1. add below code to vba.txt
Function highlightCellRedWholeRow(rowNumber As Integer, sheetName As String)
    Rows(CStr(rowNumber) & ":" & CStr(rowNumber)).Select
    With Selection.Font
        .Color = vbRed
    End With
End Function
  1. use invoke VBA in excel application scope, set function name = highlightCellRedWholeRow,
    entryMethodParameters = {rowNumber, SheetName}
    e.g. {2, Sheet1} to highlight row 2 in sheet1
1 Like