Demonstrates how to apply and edit conditional formatting.
Contains the order the ConditionalFormatting sheets are generated in.
Goes through different styling you can apply to a Conditional Formatting rule. The examples here apply to all rules except for ColorScale, Databars and Iconsets as they don't use styles the same.
Contains examples of above and below average and including equal for both.
Examples of Conditional Formatting based on standard deviation and of top and bottom x% or the bottom 4 results by using bottom rank=4
Time based conditional formatting e.g. Last7Days, yesterday,tommorow, last week/month
Formatting if there are blanks, errors or noBlanks noErrors and duplicate values
Formattings that check for text. Cell ends starts and contain given string
Format if equal or between values and custom expressions (custom formulas)
Shows how to remove a conditionalFormatting and cast them between types if needed.
The below samples behave a bit differently when it comes to styling:
Iconsets. Displays a set of 3-5 icons depending on values. You can now create your own iconset picking icons from any set.
Databar examples including options for coloring the axis and negative databar. Supports theme, auto and index colors.
Colorscale creates a 2 or 3 tone gradient from low to high. Supports theme, auto and index colors.