You would need a UDF for that, nothing built in


http://www.mvps.org/dmcritchie/excel/formula.htm



Regards,

Peo Sjoblom

"peter" wrote:

It seems like it should be possible to do this with conditional formatting,
but i can't find a function that detects whether a cell contains a formula.
any help on this is much appreciated. thanks.