| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number format in a formula | Excel Worksheet Functions | |||
| Format a cell with a custom number format | Excel Worksheet Functions | |||
| Format cell for number example 0.123 | Excel Discussion (Misc queries) | |||
| number format problem when using =A1&A2 formula | Excel Discussion (Misc queries) | |||
| How to add the number in cell one by one in Hex format | Excel Discussion (Misc queries) | |||
Threaded Mode
