However this rule only highlights individual cells, and it also catches any cells that just mention Bob.
If we want to highlight all tasks that that are assigned to Bob, we could use the Conditional formatting rule 'Text that contains' and then enter 'Bob' for the text to match. Here we have a task list that contains a number of columns - priority, task, owner, and due date. In this video, we'll show you how to use a formula with conditional formatting to highlight an entire row in a multi-column list. However, it's a little trickier to highlight entire rows in a list that contains multiple columns. Using conditional formatting, It's easy to highlight cells that match a certain condition.
