I must have asked before - memory's gone :)
But I remember something like that

Cheers


On Tue, 01 Aug 2006 17:30:08 +0100, Bob Phillips wrote:

You need a UDF and use that

Function IsFormula(rng As Range)
IsFormula = rng.HasFormula
End Function

and use that in the CF.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"SteveW" wrote in message
news:op.tdl33kuqevjsnp@enigma03...

I've got a formula in a column, but in certain circumstances I may
overwrite this formula with a number (too rare a special case to bother
covering)

What I'd like though is to use Conditional Formatting to alter cell to
Bold or something to show that this is *a manual override*

Can't see how you can check for formula present ?

Any ideas ?

--
Steve (3)





--
Steve (3)