Error With Conditional Formatting Rule Formula

I am trying to use this formula as a rule for conditional formatting.

Please Login or Register  to view this content.

Excel is reporting that there is an error with my formula, but I can't seem to find it.


Cross posted here.

Thanks Paul. This apparently won't work since I can't use references to other workbooks for conditional formatting criteria.
I don't know what to do now. I have a unique situation which is beyond my knowledge. (see my x-post)

I have overcome this by creating a column on my worksheet that references the second workbook and returns a TRUE FALSE value. The conditional formatting rule refers to that column in the worksheet rather than the data in the second workbook.

Works great, however there is a hiccup in it's accuracy when scrolled.