Exploring Conditional Formatting and Data Validation
OVERVIEW With Conditional Formatting , we’ll show you how massive amounts of data can be analyzed to visually emphasize relationships, find exceptions, and spot trends. Conditional formatting can change the format of cells based on their values in multiple ways including font style, underline style, font color, fill color and more. Adding your own formula for conditional formatting gives it a power boost to help you do things the built-in rules can’t do. Data bars can be used to show the value of a cell relative to other cells. Data bars can be modified multiple ways. Color scales shows data distribution and variation. Shades of color represent high, middle and low values. A variety of color combinations are available. Icon sets allow annotation and classification of data into three to five categories using icons. It is possible to customize icon sets. To be sure that the data is entered accurately, use Data Validation to restrict the input type of a value based on a speci...