Hi all

I am trying to think of occasions when I would use the Data Validation Rules
feature.

The only one I can think of at the moment is that if I had a new user to
Excel, I can set validation rules per column, only allowing them to enter
figures between, say, 100 and 200. It will, therefore, highlight any figures
outside these parameters that they have entered by mistake.

Can anybody think of another typical example when Data Validation would be
useful? What do other people use it for?

Thank you.
Louise