Conditional Formatting on cell with Formula

A

AGnes

I have added this code to a module on my Personal worksheet

Function ISFORMULACELL(cell) As Boolean
ISFORMULACELL = cell.HasFormula
End Function

Then on another worksheet, I enter this formula in conditional formatting:
=ISFORMULACELL(A1)

I expect any cell that contains a formula to be highlighted in yellow but it
didn't happen. Can you please help me identify what goes wrong? Thanks!
 
Top