View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
R of Steinke
 
Posts: n/a
Default how can i tell if a cell contains a formula?

How can I tell if a cell contains a formula versus a number or text? (apart
from looking at it). i want to create a conditional format for cells so that
if users enter a formula (or reference to another cell - basically anything
starting with "=" , it appears in a different format.