View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Over keying a formula - Can I set this to automatically bold ?

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