Conditonal Formatting : color the cell if it contains a formula
 

Hello,
I would like to inform the user whenever he is changing a cell which
contains a formula by a value. The sheet is not protected and will not be.
No macro. Usage of function inside the conditional formatting wizard.

Thanks for helping me !

Conditonal Formatting : color the cell if it contains a formula
 

By no VBA, I assume you also mean no User Defined function written in VBA.

Given those specifications, I would guess your out of luck.





--
Regards,
Tom Ogilvy



"Fr. Vandecan" wrote:

Hello,
I would like to inform the user whenever he is changing a cell which
contains a formula by a value. The sheet is not protected and will not be.
No macro. Usage of function inside the conditional formatting wizard.

Thanks for helping me !

Conditonal Formatting : color the cell if it contains a formula
 

Try this -

Select A1
Define a name, Ctrl-F3
name: getFormula
refers to: =GET.CELL(6,A1) don't use $A$1

select a cell for your CF,
Formula Is
=LEFT(getFormula,1) = "="

Regards,
Peter T


"Fr. Vandecan" <Fr. wrote in message
...
Hello,
I would like to inform the user whenever he is changing a cell which
contains a formula by a value. The sheet is not protected and will not be.
No macro. Usage of function inside the conditional formatting wizard.

Thanks for helping me !