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 !

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

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. (E-Mail Removed)> wrote in message
news:29D7AE1B-ADBE-4C71-88F3-(E-Mail Removed)...
> 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 !
>