IsFormula
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
|