Conditional Formula to indicate Formula in cell
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)
|