I do use data validation for some cells but the valid/not valid part is for easy checking if someone has all the required certificates to (be allowed to) do their job. I could check it manually for someone and change it manually to valid or not valid but after a while some certificates will expire so it would be great if it changed to not valid automatically in such cases. Besides checking manually would be very annoying because there are over a hundred columns.