| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Identify if Cell is Formula or written number
I run this question again.
I am novice in VBA so I have no idea how to make User Defined Formulas as written i earlier discussions. I have cells with formulas picking up data from a linked file. On and off I overwrite the cell formula with figures (1234). Then I want the conditional formatting to change the cell color to remind me that I have overwritten the formula. I suppose the answer still might be VBA, but can you then explain to a novice/rookie how to do it? Regards, Claes |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
| Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
| How do identify a blank cell in a formula | Excel Discussion (Misc queries) | |||
Threaded Mode
