Thanks sir, for quick reply

and i am sorry for not provide the complete details

Actulally, I have a sheet with many formulas, Now i a CF if some one
overwrite or Change the Formula it change the color.

I know there are many solutions. like Protect sheet or Data Validation.

But i want only CF if Possible.

Hardeep kanwar

"Jacob Skaria" wrote:

Using CF it is possible if you know what the original cell text is
OR
other wise you will have to use a macro

If this post helps click Yes
---------------
Jacob Skaria


"Hardeep Kanwar" wrote:

Is it Possible to Change Using CF.

Means if Some one overWrite the Cell it Change the Font Color.

I Try in Another Site But Couldn't Find the Solution

http://www.mrexcel.com/forum/showthread.php?t=396658

Thanks in Advance

Hardeep kanwar