Previous Topic Next Topic

If Statement in Excel that locks a cell

Closed
Alex - Dec 23, 2009 at 12:50 PM
lfefil Posts 60 Registration date Monday December 21, 2009 Status Member Last seen December 25, 2009 - Dec 24, 2009 at 10:53 AM
Hello,

I'm trying to create an IF statement in Excel 2003

If a cell is equal to a certain text string, then lock the cell and display a text string or a message box telling the user to enter a value in another cell, otherwise, the user should be able to enter text into the cell without erasing the formula.

Is this possible without writing vba code into the spreadsheet?
Related:

1 response

Answer 1 / 1
lfefil Posts 60 Registration date Monday December 21, 2009 Status Member Last seen December 25, 2009 10
Dec 24, 2009 at 10:53 AM
no this is not so possible but you can use the validation option for it have you try it?
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
phone lock <SOS>
keary88 -
Ambucias -

1 response
Forgotten input phone lock code
jared -
closeup22 -

1 response
Counting cells containing only numbers
jutulu -
jutulu -

4 responses