Hi
Im trying to restrict the values that can be entered into a cell depending on another cell. An example of my workbook is Column A = Product Purchased with data validation from a list of meat, fruit, vegetables, other, No. and column B = quantity bought.
I want to validate the cells in column B so that if products were purchased (column A = meat, fruit, vegetables, other) any number can be put in, but if no products were purchased (column A = No) No values can be entered
Im trying to use an if formula within data validation but I cant get it to work.
Any help much appreciated!
Im trying to restrict the values that can be entered into a cell depending on another cell. An example of my workbook is Column A = Product Purchased with data validation from a list of meat, fruit, vegetables, other, No. and column B = quantity bought.
I want to validate the cells in column B so that if products were purchased (column A = meat, fruit, vegetables, other) any number can be put in, but if no products were purchased (column A = No) No values can be entered
Im trying to use an if formula within data validation but I cant get it to work.
Any help much appreciated!
