View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mrbucc mrbucc is offline
external usenet poster
 
Posts: 1
Default Conditional formatting if a formula is replaced by value

I would like to set up a conditional formatting in case a cell is changed
from a formula to a text value. I can protect the cells is an option but
there are times when I will change the formula to a text but I would like to
highlight yellow.