You can base the formatting on the current field, or on any field in your model that has numerical or color data. Under Based on field, select the field to base the formatting on. To format cell background or font color by color scale, in the Format by field of the Background color or Font color dialog box, select Color scale. 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.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |