Add conditional formatting to tables in reporting

Use conditional formatting on your table charts to understand the data in your report better. You can highlight or apply color scales to number properties in your table to draw attention to the most important information. Conditional formatting can be applied to table visualizations built in the custom report builder and the single object report builder. 

• Create a table visualization in the custom report builder or the single object report builder.
• Navigate to Chart settings:
  • In the Custom report builder, click Chart settings in the center column.
  • In the Single object report builder, click Chart settings in the left column.
• In the Conditional formatting section, select the column to apply conditional formatting to. Number, currency, percentage, and duration property types can have conditional formatting applied. Learn more about property types in HubSpot.

• Click the Color palette dropdown menu and select a color palette. 
• To edit the colors applied for Min and Max, click the Min or Max color selectors and select a color. Fields that contain no value or are blank won't have a color applied.
• Click + Add midpoint, to define a middle color.

• By default, auto values will be applied to the Min, Mid, and Max fields. To define these values, enter a specific number. If there is a number below or above the min or max, the field will have the color of the min or max.

Please note: auto values show a gradient based on the values visible on the current page of the table, not all values in the column. To include all column values in the gradient, enter specific min or max values.

• To add conditional formatting to another column, click the Choose column to apply to dropdown menu and select another column. Apply your settings.
• For Duration property field types, click the Duration dropdown menu to set a time measurement for the column gradient scale.

• To delete conditional formatting that has been applied to a column, select the column from the Choose column to apply to dropdown menu, then click delete Remove conditional formatting.