Lesson 17 Flashcards
A type of conditional formatting that creates filled background bars reflecting the relative value stored in each of the format cells
Data bars
Variable formatting that changes the formatting applied based on the contents of the cells in the formatting range.
Conditional formatting
A method of applying conditional formatting based on how cell contents compare with a specified criterion, such as a less than comparison
Highlight cell rules
A type of conditional formatting that includes one of a set of icons reflecting the relative value stored in each of the formatted cells
Icon sets
A tool that provides formatting for data analysis
Quick analysis lens
Conditional formatting rules that format the highest or lowest values in the formatted range, or those that are above or below average
Top/bottom rule
