Hello,
I have 2 Columns in a Excel Sheet. Column A has drop down values and Column B is a free text.
What I want is that When the user selects a Value in Column A which is less than 2 then the user should not be able to enter anything in Column B, basically the Column B should become read only.
And maybe I can also display a message to the user that because they entered a value less than 2 they cannot enter anyhting in Column B.
I am new to Excel so please advice.
Bookmarks