Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to determine whether cell contains a formula?
All,
Is there a function (eg, in the form of =ISFORMULA(_)) that will return a code if a cell contains a formula as opposed to a blank or a text or value? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to determine whether cell contains a formula?
Well, there's a macro you can use called GetFormula:
http://www.mvps.org/dmcritchie/excel/formula.htm Once installed you use it as an ordinary function: =getformula(A1) etc. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Don" wrote: All, Is there a function (eg, in the form of =ISFORMULA(_)) that will return a code if a cell contains a formula as opposed to a blank or a text or value? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to determine whether cell contains a formula?
Hi Don:
Remember, without any custom functions, you can locate all cells containing formulae and count them: first set the status bar to COUNT next: Edit Goto Special formulas -- Gary's Student gsnu200708 "Don" wrote: All, Is there a function (eg, in the form of =ISFORMULA(_)) that will return a code if a cell contains a formula as opposed to a blank or a text or value? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to determine whether cell contains a formula?
Gary's Student,
Thanks! I should have been more specific about my use. I am trying to set up a spreadsheet to project due dates for activities that are calculated. Once the activity is completed, the user would enter a date into the field (replacing the calculation). I want to use conditional formatting to color the cells differently based upon whether a date is projected (eg, calculated with a formula) or actual (based upon a value being present in the cell). I think that the other reply will help, although I haven't been able to get it to work yet. "Gary''s Student" wrote: Hi Don: Remember, without any custom functions, you can locate all cells containing formulae and count them: first set the status bar to COUNT next: Edit Goto Special formulas -- Gary's Student gsnu200708 "Don" wrote: All, Is there a function (eg, in the form of =ISFORMULA(_)) that will return a code if a cell contains a formula as opposed to a blank or a text or value? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to determine whether cell contains a formula?
Dave,
Thanks! I think that this will work, although I haven't been able to get it to take yet in VBA programming (since I know next to nothing about VBA programming!). However it is a good start and with a little tinkering it looks as if it will do exactly what I want. Thanks! "Dave F" wrote: Well, there's a macro you can use called GetFormula: http://www.mvps.org/dmcritchie/excel/formula.htm Once installed you use it as an ordinary function: =getformula(A1) etc. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Don" wrote: All, Is there a function (eg, in the form of =ISFORMULA(_)) that will return a code if a cell contains a formula as opposed to a blank or a text or value? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Value of cell to determine range in MAX Function | Excel Worksheet Functions | |||
Is there a way to determine which cell the function =min() used? | Excel Worksheet Functions | |||
Code to determine if a cell contains an array function? | Excel Discussion (Misc queries) | |||
Function to determine if any cell in a range is contained in a given cell | Excel Worksheet Functions | |||
Is there a function to determine whether a cell contains a formul. | Excel Worksheet Functions |