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)
    ActiveWorkbook.Sheets(sheetName).Activate
    Rows(CStr(rowNumber) & ":" & CStr(rowNumber)).Select
    With Selection.Font
        .Color = vbRed
    End With
    ActiveWorkbook.Save
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