Format Cell formula vs number
thank you much for help.
"Gord Dibben" wrote:
The UDF is to be copied and pasted to a general module in your workbook.
It is a Function, not an event.
Alt + F11 to open VBE then CTRL + r to open Project Explorer.
Right-click on your workbook/project and InsertModule.
Gord
On Mon, 30 Apr 2007 14:04:02 -0700, nastech
wrote:
hi, thanks; seems I have hardest time with code.
with this example pasted on sheet 2 tab, (right-click, view code, paste..)
did hit save, not sure if necessary; entering a cond. format for background
to go red (for: =isformula(K12)), nothing happens for any present of:
formula, number, empty, text
imagine something simple i am missing
"Gord Dibben" wrote:
Add this UDF to a module in your workbook.
Function IsFormula(cell)
IsFormula = cell.HasFormula
End Function
In CFFormula is: =IsFormula(cellref)
Gord Dibben MS Excel MVP
On Mon, 30 Apr 2007 11:32:01 -0700, nastech
wrote:
Hi, is there a formula for cond. format, if cell is formula / not a formula,
then no formatting / background color. this would occur if typing a number
in place of formula. thanks
|