| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how can i test whether cell contains keyed constant or a formulae
I would like to use conditional formatting to test whether a cell contains text or a formulae and higlight all cells as they are overtyped. I have tried using Type() but doesnt recognise difference between sam a number keyed in and a formulae beginning =if(. . . . Any ideas? -- Ruthki ------------------------------------------------------------------------ Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503 View this thread: http://www.excelforum.com/showthread...hreadid=380978 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Test a cell for a formula present | Excel Discussion (Misc queries) | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
