work in progress….

Conditional formatting comes handy if there is too much data to put into a graph or if you quickly want to analyze data in large dataset. This is how it works:

Data bars

  1. As usual, the first thing to do is to apply table formatting to your dataset, since this will allow us later to sort and filter our data based on the conditional formatting we apply. But in order have the conditional formatting work best, select a table layout that only colors the headline (the first table layout is usually without color)
  2. Select the column of your table in which you like to show the data bars
  3. Go to conditional formatting at Home > Conditional Formatting > Data bars
  4. Under more rules, Excel allows to adjust the data bars settings, for example if you have outliers you might want to redefine the minimum or maximum values for your data bars. Of course, you can also change the color how the the data bars are shown

Icon Sets

You can use your icon sets.

 

Highlighting cell rules 

  • Greater Than
  • Less Than
  • Between
  • Equal To
  • Text That Contains
  • Date
  • Duplicate content

Heatmaps / Color Scales

 

Top/ Bottom Rules

 

Customized formulas

If you want to base highlighting rules on conditions that depend on more than one cell, you need to use formulas. In other words, if the highlighting of one cell is based on the value in another cell, you need to apply formulas.

For instance, only highlight cells click rate if the keyword got more than 100 impressions. Let´s do this:

conditional formatting with formuals

conditional formatting with formuals

Another obvious use case is to create a list of your collectibles and when you can enter a “y” for payment received, the positions gets colored green.