You can add this User Defined Function to your workbook.

Function IsFormula(Cell)
Application.Volatile
IsFormula = Cell.HasFormula
End Function

Select the range to Format then

FormatConditional FormattingFormula is: =isformula($A1)

I assumed the range was in column A.


Gord Dibben MS Excel MVP

On Wed, 16 Aug 2006 08:16:01 -0700, Dave wrote:

Hi All,

Hopefully this is a nice easy one that somebody can help me out with :-)

I have a column of data with formula's in (forecasted sales) during the
month I over key these when the actual orders come in. Is there a way that I
can set something up so that when I over key the formula the text changes in
some way either a different colour or bold for example. I have tried using
conditional formatting but don't seem to be getting anywhere.

Thanks in advance for your help

Regards

Dave