Forum Discussion
Jrhodes303
May 02, 2023Copper Contributor
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...
Roger Govier
May 03, 2023MVP
You only need E2="Y"
That will either be True or False.
That will either be True or False.
Jrhodes303
May 03, 2023Copper Contributor
Hi Roger Govier,
Thanks for your reply. I'm assuming you mean =E2="Y".
With that formula in the custom validation, it still allows entry if E2 is left blank. That's why I added the addtional statement E2<>"", but that had no effect. For context, E2 also has a validation list of Y or N. If neither is selected, any value is still allowed in the cell with validation rule =E2="Y". I don't think the validation list in E2 has any effect because without validation list in E2, the same thing happens: Validation in F doesn't work if E is left blank.
- HansVogelaarJun 13, 2024MVP