Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A function to indicate whether a cell contains formula or value?
Is there a function to return logical indication of whether a cell contains
formula or value? Need it for conditional cell formating. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A function to indicate whether a cell contains formula or value?
Not built in
http://www.mvps.org/dmcritchie/excel...htm#HasFormula -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Dave T" <Dave wrote in message ... Is there a function to return logical indication of whether a cell contains formula or value? Need it for conditional cell formating. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A function to indicate whether a cell contains formula or value?
With a User Defined Function such as
Function IsFormula(cell) Application.Volatile IsFormula = cell.HasFormula End Function Gord Dibben MS Excel MVP On Wed, 7 Jun 2006 13:18:02 -0700, Dave T <Dave wrote: Is there a function to return logical indication of whether a cell contains formula or value? Need it for conditional cell formating. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
IF Function to test formula in a cell | Excel Worksheet Functions | |||
revealing the contents of a formula | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |