Welcome to Clippy, the eLearnOffice Blog
We help you get the most from Office and keep your Skills up to date JOIN FOR FREEThis is a template for a blog post
How to create a menu of options that when selected will change the colour of the cell. For example, selecting Cancelled from a list should change the cell background colour to red to indicate clearly to the user that the project or course etc. has not been given the go ahead.
What is Data Validation?
The data validation feature in Excel can be very useful when creating forms or reports. It helps you to control what can be entered by a user in your worksheet or template. For instance you can create dropdown menus within a cell, restrict data entry such as text length as well as create custom rules containing various functions.
Step by Step walkthrough
1. What is Data Validation?
The data validation feature in Excel can be very useful when creating forms or reports. It helps you to control what can be entered by a user in your worksheet or template. For instance you can create dropdown menus within a cell, restrict data entry such as text length as well as create custom rules containing various functions.
2. What is skjvbsjk?
The data validation feature in Excel can be very useful when creating forms or reports. It helps you to control what can be entered by a user in your worksheet or template. For instance you can create dropdown menus within a cell, restrict data entry such as text length as well as create custom rules containing various functions.