Thread: IsFormula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gerritvanzyl
 
Posts: n/a
Default IsFormula

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