Hi
Does anyone know of a function that can be used to dtermine whether the contents of a cell are hardcoded or function results.
i.e. distinguish between "6" and "=2+4" or indeed "=yearfrac(X, Y)" or any other expression.
Im trying to create a conditional format expression that highlights where a user has overwritten (intentionally) a formula.
Thanks
Bit odd replying to my own post, but Ive had a little help from another source and licked this using:
http://www.tek-tips.com/viewthread.cfm?qid=486151
and changing the INDIRECT reference to the current cell when using in Conditional Formatting.
Works a treat.
To make good use of this I have set up the defined function "=GET.CELL(48,INDIRECT("rc",FALSE))" and it's insertion iinto a cell's conditional formatting by macro into my template. This means that when building models that may require some inidividual forumla to be overwritten/hardcoded, rather than having to remember to flag them the sheet does it for you.
Last edited by stoner; 10-23-2006 at 11:54 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks