Home For AAT student members AQ 2016 Advanced Diploma in Accounting General discussion - Advanced level
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚


Excel, Data Validation

LhughesLhughes Just JoinedRegistered Posts: 19
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?

Comments

  • LhughesLhughes Just Joined Registered Posts: 19
    All sorted just me having a moment with excel!!
Sign In or Register to comment.