I have a comment form and sheet on my site:
• Column A: Timestamp
• Column B: Name
• Column C: Comment
I'd like to highlight every row that includes the admin's answer. In other words, if a cell in column B has the text Admin, its entire row should have a background color. How should I use conditional formatting or something like that to achieve it?