In this article, we have a data entry form for candidate information with minimum VBA. We have used Excel formulas, conditional formatting and Form Controls. You can replicate this template in your office and make the necessary changes. We have put the validations for Mobile number and email id using excel logical formulas.