Excel, Data Validation

Lhughes
Lhughes Registered Posts: 20 New contributor 🐸
Hi, I am having a blank moment and hope someone can help asap!! So I am using Data Validation on an excel spreadsheet, I need to use data validation to ensure that only people aged between 30-50 are included, and then circle the ones that do not fall into this range however,I am not sure why excel is circling all other 255 cells, I just want the number range? Can someone advise please?

Many Thanks

Comments

  • Lhughes
    Lhughes Registered Posts: 20 New contributor 🐸
    Hi, I am having a blank moment and hope someone can help asap!! So I am using Data Validation on an excel spreadsheet, I need to use data validation to ensure that only people aged between 30-50 are included, and then circle the ones that do not fall into this range however,I am not sure why excel is circling all other 255 cells, I just want the number range? Can someone advise please?
  • Lhughes
    Lhughes Registered Posts: 20 New contributor 🐸
    All sorted just me having a moment with excel!!
Privacy Policy