View Single Post
  #1   Report Post  
rrucksdashel
 
Posts: n/a
Default Checking for a formula

How can I tell in a cell on one sheet if a cell on another sheet is an input
value or a formula (e.g., 4 or =2*2)? I use the conditional formatting
=(HasFormula) when the cell that I am checking is on the same sheet but
conditional formating won't let me reference another sheet (I don't think)