The CF does not refer to another sheet. (it refer to the same cell its in)..
BUT whenever I want to reference to a cell in this sheet with the CF from
another sheet problems starts..

"Gord Dibben" wrote:

When you try to use the UDF Isformula in a CF you should be getting the error
message that you "cannot use references to other sheets or workbooks for CF
criteria"

I know of no workaround but someone may jump in with a solution.


Gord Dibben MS Excel MVP

On Fri, 9 Jun 2006 12:23:01 -0700, Gerritvanzyl
wrote:

I use this Isformula UDF... in one of my sheets I however run into the
following weird problem..

Whenever I try to refer to an sheet using this IsFormula in a conditional
format... It does not work... Rather than using the refered cell as a dynamic
link...

Let me give an example:
Sheet2 have the following conditional format
=AND(NOT(Isformula(A1)),NOT(A1=0))

Say I start in Sheet1, Cell A1 typing a "+" then select sheet2 and cell
A2... rather than putting a reference in Sheet1,A1 excell put the following
in sheet2,A1 "=+'Sheet 2'!A2"

Hope someone out there can help me