Use conditional cell formatting in tables and Gantt charts to highlight individual cells, columns, or rows.
Overview
Select Cell formatting [1] from the column or row header, the table options.
...
Use the option Apply to all row cells [5] to apply color/background/font style to all cells in a particular row. If some other column in the report also has formatting, then conditions are merged in cells in this column (formatting from another column is applied if text, background, or font in this column has a default selection).
Range
Specify ranges of values that should have different formatting. Can be used for numeric values, percentages, intervals, or dates. Both min and max end-point values are included in the range.
For dates, use exact dates or relative dates to define a range. If the date is a DateTime value (also has a precise time, e.g. Issue creation date, Issue resolution date), the start of this date (00:00) is always used, take it into account when defining Max value (add one more day).
...
Use exact value to apply rules for text or integer numerical values. This approach is recommended if you have a few specific or unique values (e.g., statuses for texts, story points for numbers) and you want to color-code cells by them. Use precise and case sensitive value. Select the Empty checkbox to highlight cells with empty values.
Example
Using exact value condition, color lighter the text in all cells for issues with resolutions Duplicate or Won't Do.
...
Use regular expression to apply rules for text containing some pattern (e.g., starts, ends, or contains specific characters). Use Regular expressions to define the pattern. When used for date values then the date text representation (using the measure date formatting) will be used.
Example
Using a regular expression, color all rows with issues having any label (i.e., having any value in the "Issue labels" column). A regular expression . is used to match any character.
...
Report with applied rules:
Top/Bottom
Use Top/Bottom to highlight the top and/or bottom cell values. If several values are the same then all cells matching top/bottom values are selected. This option is recommended for numeric values and dates.
...
Report with applied rules:
Heatmap
Highlight all values using different intensity colors from the specified color range. By default, minimum, midpoint, maximum values are detected automatically. If necessary, exact values could be specified. For example, specify midpoint value 0 to highlight negative values using one color and positive values using a different color. Heatmap option is recommended for numerical values and dates.
...
Report with applied rules:
Using custom formula
By default, the cell measure value is used for selecting the matching rule. In some specific cases, you can override it with a custom calculation formula. Custom calculations use the same MDX expressions as calculated member formulas. You may use an already existing measure as a custom calculation or write the calculation directly in this same form.
...