Conditional Format Using Formula By Referring To Another Sheet

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

Moved post to http://www.excelfox.com/forum/f2/loo...sing-vba-1042/