Conditional formatting functions
Conditional formatting is a format, such as a cell shading or font color, that's automatically applied to cells if a specific condition is met (true). When the condition is met, a specific cell format is applied to the cells to answer any queries you may have about your data. Finding duplicate worksheet data is another great use of this tool.
In this section, you will learn how to create colored lines across workbook data when certain conditions have been met. We will be using the following validation rules and colors:
We will cover the following two skills:
- The first is to set up a validation rule to make sure that data entered into a specific column on the worksheet is constrained to certain values. This is a great feature to include in the workbook when you're working collaboratively as it ensures that if any other data is entered by a user, it...