Conditional Formats
Microsoft Excel has a library of Conditional Formatting
including Data Bars, Color Sets and Icons.
Each of these formats is based on Conditional Formulas,
or Rules. Let's start with a simple Rule: show me any amount that
is above the average.
2. Try It: Above or Below Average?
Select Column H.
In the sample spreadsheet, this is the
column with the Amount.
Go to Home ->Styles.
Go to Conditional Formatting.
Go to Top/Bottom Rules.
Select: Above Average.
Keep going, you will be prompted...
