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.