Conditional Formt IF cell contains formula with specific text

Hi all I have hit a weird challenge.
I need to format cells that contain a formula that contain a "[Device Log Book.xlsx]" without the quotes

So I solved the first problem where i can conditonal format cells that contain a formula, i used this guide i found off of bing: http://j-walk.com/ss/excel/usertips/tip045.htm

It works awesome, but now i need to test the contents of the formula. Please help.

Thanks

Seperate post because this is another question:
On further though, actually this is what I initally tested. I create a conditional format to search cells if it contains specfic text of "[Device Log Book.xlsx]" BUT that seems to look at the value of formulas no the formula text . Does anyone know how to make this search formulas as well?
Thanks

Originally Posted by martindwilson

try defining a name eg myname
=ISNUMBER(SEARCH("[Book7]",GET.CELL(6,INDIRECT("RC[0]",FALSE))))
then use cf as =myname

Thanks martin that worked perfect! Thanks so much I struggled with this a lot before I posted and then you replied so fast! Thanks!!