Conditional Formatting
 

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 !.

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 !.

Conditional Formatting
 

Thanks for the proposition.


"Bob Phillips" wrote:

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 !.