Highlighting Data with Conditional Formats

Conditional formats are another way to display important aspects of your data. You can use the graphical capabilities of conditional formats to display the relative values of data such as a bar, gradients, or icons, or you can create rules to highlight which cells represent certain relationships, such as those greater than a given value.