Conditional Formatting
Create a UDF like so
Function IsFormula(rng As Range)
IsFormula = rng.HasFormula
End Function
and then use that in the CF like so
=IsFormula(C2)
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"François" wrote in message
...
Hello,
I have some cell which have by default formulas. However the user may
change
that and change the formula by a value.
Question : what kind of condition do I need to put on the conditional
formatting to have those modified cellls (no more formula but value) a
different color .?
Many thanks for your help !.
|