help with formula

[djs6025]

Hi Everybody,
I know this is one is probably an easy one for you all. I have a long error report with over 10k lines I need help with. Attached is a sample of the spreadsheet. Column J shows which line the error is located on on the spreadsheet. Is there a way to highlight the row where the error shows up? For instance, cell J2 says "Line 3: Validation failed: Image failed to download.". Can a formula be written to highlight line 3 in red? As always, thanks so much for your help.


https://imgur.com/a/1ntKpeT


Thanks,
Dan

 

[Michael M]

Can't be done by formula, but I had a VBA solution in my archives.
I'm sue there will be simpler code, but it works for me...

Sub MM2()
Dim lCount As Long, l As Long, sText As Variant
Dim lNum As String, lr As Long
Application.ScreenUpdating = False
lr = Cells(Rows.Count, "J").End(xlUp).Row
For Each sText In Range("J2:J" & lr)
    For lCount = Len(sText) To 1 Step -1
        If IsNumeric(Mid(sText, lCount, 1)) Then
            l = l + 1
            lNum = Mid(sText, lCount, 1) & lNum
        End If
    If l = 1 Then lNum = CInt(Mid(lNum, 1, 1))
    Next lCount
Rows(lNum).Interior.Color = vbRed
lNum = ""
Next sText
Application.ScreenUpdating = True
End Sub