Microsoft Excel | Data validation and conditional formatting
Learn to enhance your spreadsheets by combining data validation and conditional formatting. Set up rules to control data entry, create custom error messages for immediate feedback, and apply advanced techniques to dynamically format cells.
Where to next?
What is data validation?
How can data validation help control data added to spreadsheets and why using it will improve consistency and data quality
This training is specifically designed for Windows devices.
If you're using an Apple (macOS) device, please refer to the appropriate shortcuts and instructions for your system. Click here for Apple device shortcuts and guidance.