Name the cell on the other sheet (select cell., do insertnamedefine)then
refer to the name in the formatting

=HASFORMULA(name_cell)

--
Regards,

Peo Sjoblom

(No private emails please)


"rrucksdashel" wrote in message
...
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)