Vlookup Question-What I want to add?

[geokin]

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

[dcgrove]

Use conditional formatting in the cells you want to change. You will not be able to do it with a formula alone.