I have certain things written in my A column.
I want to write conditional formatting to highlight an entire row if the A column contains the words '0-UNEXPECTED'
I've tried this... but I have no idea what i'm doing.
=AND(ISNUMBER(Search('0-UNEXPECTED',$A2)))
Thanks!![]()
Bookmarks