In this article
Use Conditional Formatting in aggregated tables to highlight cells in a table based on results. This highlighting is dynamic and is controlled by the results displayed in the table, so as respondents reply to the survey and the report is updated, different cells may be highlighted.
In the example below, conditional formatting is applied to column 2 ("Percent favorable") and column 5 (average). In column 2, scores below 50% are highlighted with a red background color, and scores greater than or equal to 55% are highlighted in green. In the last column, averages greater than or equal to 3.5 are highlighted in green.
Figure 1 - Conditional Formatting applied to a table
Note: Conditional Formatting uses the rounded values of a cell.
Once you have set up a conditional formatting area, you can duplicate it to save time when creating more areas.