Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting links | Excel Discussion (Misc queries) | |||
Where is the source of the data? | Excel Discussion (Misc queries) | |||
isformula? | Excel Worksheet Functions |