Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check if a cell is blank and, if so, apply a formula
Hi Programmers,
I'm trying build an Excel app. that is user friendly. In a column (C), a user may enter a nickname. If there is no nickname, then the value that was in the first name field (B) is auto copied to the nickname field (such as =B2). If a user enters a nickname, then deletes the nickname, how can the underlying formula (=B2) be reapplyed to the cell automatically? Also, I'm concerned about if the user manually enters a nickname in the last record, then adds another row manually or with a macro that copies formulas and formatting to the new row--any formula overwritten would not be included. Just curious; thanks, Arnold |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting - check for blank cell | Excel Discussion (Misc queries) | |||
How to... apply the same formula to every cell? | Excel Discussion (Misc queries) | |||
How to check for blank cells with formula | Excel Discussion (Misc queries) | |||
check to see if a cell is blank if not populate adjacent cell wit. | Excel Discussion (Misc queries) | |||
How can I check a cell for current date and insert it if blank? | New Users to Excel |