I have the attached Excel spreadsheet designed for data entry. For the columns titled MUAC COLOR and MUAC NUMBER, I would like to prevent the data entry clerks from entering data in these cells if the age of the person is greater than 5 years old.
I already have data validation rules set for MUAC COLOR to allow a drop down list to appear, and I have restricted the value they can enter for the MUAC NUMBER as it should be between 50 and 300 mm.
However, I want to further restrict the user from entering values in these cells if the value in the AGE column is not between 1-5 years old because this MUAC questions are only relevant for children aged 1-5 years old. (Last year when I got the data back, there were many cells entered for people who were aged 35 or 68 so I know that's a data entry error. I want to alert the user that they are about to make an error before it happens. )
I don't know how I should do this with a function or with more data validation rules or what?
Any help is greatly appreciated.