View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cimjet[_2_] Cimjet[_2_] is offline
external usenet poster
 
Posts: 95
Default Conditional Formatting-No Formulas

Hi YvanM
If you go to Menu Tools/Option /View/ Window Options and select Formulas
All the formulas on that sheet will show up.
Hope that helps
Cimjet
"IvanM" wrote in message
...
I want users to be able to see where they have over-written a formula with
text or a value (don't care which). I can't find a function that
determines
whether a cell contains a formula. Is there such a function? Or is there
some other way to accomplish this?
thanks