G Guest Jun 7, 2006 #1 Is there a function to return logical indication of whether a cell contains formula or value? Need it for conditional cell formating.
Is there a function to return logical indication of whether a cell contains formula or value? Need it for conditional cell formating.
P Peo Sjoblom Jun 7, 2006 #2 Not built in http://www.mvps.org/dmcritchie/excel/formula.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
Not built in http://www.mvps.org/dmcritchie/excel/formula.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
G Gord Dibben Jun 8, 2006 #3 With a User Defined Function such as Function IsFormula(cell) Application.Volatile IsFormula = cell.HasFormula End Function Gord Dibben MS Excel MVP
With a User Defined Function such as Function IsFormula(cell) Application.Volatile IsFormula = cell.HasFormula End Function Gord Dibben MS Excel MVP
