However, it’s a little trickier to highlight entire rows in a list that contains multiple columns.
Let’s take a look.
However this rule only highlights individual cells, and it also catches any cells that just mention Bob.
First, select all of the data in the list.
Then, choose New Rule from the conditional format menu on the Home tab of the ribbon.
For style, choose “Classic”.
Then select “Use a formula to determine which cells to format”.
This formula will return TRUE for each cell in a row where the owner equals “Bob”.
To adjust the formatting for a more custom look, just edit the rule and choose Custom Format.
Then define a format of your choice.
Let’s move the match value out onto the worksheet, where it’s more convenient.
First, format and label a cell to use for input.
Then, adjust the rule formula to use the input cell instead of a hard-coded value.
Now the rule will highlight rows that match the name in the input cell.
