Forum Discussion
Data Validation to lock a cell based on value in another cell.
Hello Excel Community, I have a relatively simple spreadsheet with several validation rules and conditional formatting applied. My data is in a table with headers in Row 1. Table Column E ha...
Thanks again. This is slightly different. I don't want a drop down in the cell.
If Column 1 starts with B, user cannot type in Column 3. If Column 1 does not start with B, user can type in Column 3.
If Column 1 starts with B, user cannot type in Column 3. If Column 1 does not start with B, user can type in Column 3.
You cannot do that with data validation, it requires that you protect the sheet and use VBA code.
It would only work in the desktop version of Excel for Windows and Mac, and all users would have to allow macros. Would that be OK?
- yes, what if i wanted to have two letters, for example
=LEFT(A1,2) <> "BC" Does this rule do what you want?
When I try to enter text in a row where column A does not begin with "B":
- Hmmm....could I put a max character limit on a Column 3 if Column 1 starts with B? The cell would not be locked from editing, but having len<1 and a custom error message could work. I just dont know how to do the formula.