1. Select columns A to I.
2. Go to Format Conditional Formatting
3. Select "Formula Is" on the drop-down arrow, and put:
=$D1="Bill G"
4. Press the Format radio button and format as desired.

HTH
Jason
Atlanta, GA

-----Original Message-----
If any cell in column D:D contains desired data in
string format ( i.e.
"Bill G" ), how would I highlight the data range in that
respective row?

Example:

cell d4 contains the text "Bill G". Excel automatically
colors the range
4a:4i in red.
.