View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Neil Pearce Neil Pearce is offline
external usenet poster
 
Posts: 109
Default Conditional Formatting: Fill Cell if Formula Overwritten

Dear all,

Cell A1 contains a formula.

How would I go about conditonally formatting A1 such that the cell will be
filled if the formula is overwritten by a hard number?


Thanks in advance,

Neil