Dave,

Sorry, but running event code will dump Excel's memory stack, prevent Undo.

Try Gord's solution of using the UDF in the Cond. Formatting.

HTH,
Bernie
MS Excel MVP


"Dave" wrote in message
...
Thanks for that Bernie,

It does exactly what I want, a couple of things though.......:-)
It appears to have disabled my undo button, I can't seem to undo any of my
often keying errors and if I try to recopy the formula back in to the cell
after I have over keyed, it doesn't put the formula back in only the value of
what the formula would be. I've tried taking the event back out and things go
back to normal

Any suggestions?

Thanks again

Dave

"Dave" wrote:

Hi All,

Hopefully this is a nice easy one that somebody can help me out with :-)

I have a column of data with formula's in (forecasted sales) during the
month I over key these when the actual orders come in. Is there a way that I
can set something up so that when I over key the formula the text changes in
some way either a different colour or bold for example. I have tried using
conditional formatting but don't seem to be getting anywhere.

Thanks in advance for your help

Regards

Dave