Conditional Formatting Partial

Using your example:

Select A2:A29 (or however far down you want).
A2 should be the active cell in the selection.
Create a conditional formatting rule with formula

=AND(A2<>"", OR(LEFT(A2, 3)=$D$2:$D$1000))

Select D2:D29 (or however far down you want).
D2 should be the active cell in the selection.
Create a conditional formatting rule with formula

=AND($D2<>"", COUNTIF($A$2:$A$1000, $D2&"*"))