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