To take TM's idea one step further...
http://spreadsheetpage.com/index.php...al_formatting/

HTH,
Ryan--


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Teethless mama" wrote:

create a define name call HasFormula
Refers to: =GET.CELL(48,INDIRECT("RC[-1]",FALSE))

Assuming your data in Column A
In column B type: HasFormula
If the cell has A formula it returns TRUE, else FALSE


"lessburgfred" wrote:

I would like to be able to test if a cell has a formula - or not. Prefer to
return a logical.
Thanks