You can also use custom logic to apply colors to the font or background. If you have a field or measure with color name or hex value data, you can use conditional formatting to automatically apply those colors to a column's background or font color. In the above example, in a range of percent values from 21.73% to 44.36%, 50% of that range is 33%. If you use Percent instead of Number for fields containing percentages, you may get unexpected results. In this example table with rules-based background color on the % revenue region column, 0 to 25% is red, 26% to 41% is yellow, and 42% and more is blue: For example, 'If value is greater than or equal to 0 Number and is less than. Also, select Number instead of Percent for the number format. If the field the formatting is based on contains percentages, write the numbers in the rules as decimals, which are the actual values for example, '.25' instead of '25'. So, for example, if the lowest data point was 100 and the highest was 400, the above rules would color any point less than 200 as green, anything from 200 to 300 as yellow, and anything above 300 as red.Īn example table with rules-based background color formatting based on Percent in the Affordability column looks like this: When you select Percent in this dropdown, you’re setting the rule boundaries as a percent of the overall range of values from minimum to maximum. Cell backgrounds or fonts in each value range are colored with the given color. Each value range has an If value condition, an and value condition, and a color. Under Rules, enter one or more value ranges, and set a color for each one. Again, What field should we base this on? shows the field to base the formatting on, and Summarization shows the aggregation type for the field. To format cell background or font color by rules, in the Format style field of the Background color or Font color dialog box, select Rules. The example table with color scale font formatting on the Affordability column looks like this: Select the Add a middle color check box to also specify a Center value and color.Īn example table with color scale background formatting on the Affordability column looks like this: Drop down and select the colors swatches you want to apply to the minimum and maximum values. Under Minimum and Maximum, choose whether to apply the color scheme based on the lowest and highest field values, or on custom values you enter. Under Default formatting, select a formatting to apply to blank values. Under Summarization, specify the aggregation type you want to use for the selected field. You can base the formatting on the current field, or on any field in your model that has numerical or color data. Under What field should we based this on?, select the field to base the formatting on. To format cell background or font color by color scale, in the Format style field of the Background color or Font color dialog box, select Gradient. If you make a field's font and background the same color, the font blends into the background so the table column shows only the colors. You can apply the same or different conditional formatting to a field's font color and background color. The Background color and Font color options are the same, but affect the cell background color and font color, respectively. After selecting conditional formatting options, select OK. The Background color or Font color dialog box opens, with the name of the field you're formatting in the title. To format cell background or font color, select Conditional formatting for a field, and then select either Background color or Font color from the drop-down menu. You can combine more than one option in a single table column.

The following sections describe each conditional formatting option. To remove conditional formatting from a visualization, select Remove conditional formatting from the field's drop-down menu, and then select the type of formatting to remove. Conditional formatting overrides any custom background or font color you apply to the conditionally formatted cell.

Tableedit app conditional formatting