Jun 15 2022 07:21 AM
I need to do 2 things with a cell in Excel:
1. Limit data entry to the values 0-3.
2. Do not allow data entry in the cells until the value of another cell = 48.
Can I do this in Excel? It seems like you can only have 1 data validation rule per cell.
Jun 15 2022 07:40 AM
Solution
Assuming another cell is A1 and your Data Validation is on B1, use the following Custom formula:
=AND(A1=48, B1>=0, B1<=3)
Jun 15 2022 08:22 AM
@L z.that did the trick! thank you very much!
Jun 15 2022 10:37 AM
Jun 15 2022 07:40 AM
Solution
Assuming another cell is A1 and your Data Validation is on B1, use the following Custom formula:
=AND(A1=48, B1>=0, B1<=3)