Conditional Format Using Formula By Referring To Another Sheet

[paul_pearson]

Hi Excel fox

How would you do this without VBA.The picture when it inserts automatically sizes to the merges cells.

I am interested if this is achievable without VBA

Thank you

Paul