Welcome to Clippy, the eLearnOffice Blog

We help you get the most from Office and keep your Skills up to date
JOIN FOR FREE

This is a template for a blog post

by | Feb 23, 2017 | Excel |

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.

Learn Microsoft Excel

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.