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 has validation applied as a drop down list with "Y" or "N" as choices. I'm trying to block input in table column F unless the corresponding cell in column E2 equals "Y". I've done so much searching and as far as I can tell the following formula should work:

=AND(E2="Y",E2<>"")

This works as expected if "N" is selected in Column E, but if E is left blank, column F is still open for any value.

What am I doing wrong??

MicrosoftÂ® ExcelÂ® for Microsoft 365 MSO (Version 2303 Build 16.0.16227.20202) 32-bit

Many thanks!!