if function for finding specific cells in formulae

I hope that works.

Where it says now only "yes" in column R it would be great to have a formula that identifies if a specific cell from columns S-Z appears in the formulas in columns A-Q.

Can do?

Thanks a lot.