I have this vlookup to search through col A and find a match in col d returning a yes or no in col b (where applied)

=IF(ISNA(VLOOKUP(A2,$D$2:$D$7320,1,FALSE)),"No","Yes")

What I want to add, if a match happens in col d either color the cell or bold contents.


Thanks