Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting links Newbie Excel Discussion (Misc queries) 8 May 23rd 06 09:16 AM
Where is the source of the data? Brisbane Rob Excel Discussion (Misc queries) 13 March 2nd 06 10:33 AM
isformula? dave Excel Worksheet Functions 10 March 27th 05 08:12 PM


All times are GMT +1. The time now is 09:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"