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 I need help with. Attached is a sample of the spreadsheet. Column J shows where the error is located 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

 

[mole999]

conditional format on the column where it contains the word failed, will be examples on the web, or just use that in a text filter, and drag a colour over the returns, it really depends on how many and how often you need to do that