Limit an Excel cell to one of two possible values
Fresh3 days ago
Mar 15, 2026173297 viewsConfidence Score0%
0%
Problem
I would like to create a cell format for one cell to only allow the value "yes" or "no" for this cell. How could I do this?
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Limit an Excel cell to one of two possible values
Low Risk
Microsoft describes this here: Apply data validation to cells Click the cell you want to restrict value for Go to Data -> Validation. The Data Validation dialog box opens In the Allow dropdown select List In the Source text box enter Note: This will…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix