Highlight specific cells in a column next to a column that contains the same value

DataSet-where-you-want-to-highlight-rows-where-name-is-Bob.png

Hello All.

I wanted to now base on the dataset, how do I highlight the cells only in column D that are next to a cell in Column C that has the same value "Bob"

So I just want to highlight all of Bob's quantity only

Thanks,

Or you could use conditional format.
Select D2 to the end of the column > Home tab > Conditional Formatting > New rule > Use a formula >
=C2="Bob"
Select the format you want