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?

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

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

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

1 response
Excel - IF function with multiple words
Nick -
user -

14 responses
Facebook account locked
Alexnder -
HelpiOS -

1 response
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses