Master HubSpot Table Formatting for Better Reports
Using conditional formatting in Hubspot table reports helps you highlight critical metrics, spot trends faster, and make complex data easier to understand for your team.
This guide walks you through every step of adding and editing conditional formatting in custom report tables so you can turn plain grids into powerful visual summaries.
What Is Conditional Formatting in HubSpot Reports?
Conditional formatting in HubSpot table reports lets you apply colors to specific cells based on rules you define. This makes it easy to see when values are above, below, or within important thresholds.
You can use it to:
- Highlight top-performing deals or campaigns
- Flag low conversion rates or slow response times
- Visualize ranges such as low, medium, and high values
- Compare performance across owners, teams, or time periods
The feature is available in custom reports that support table visualizations, giving you more control over how your data appears inside your HubSpot analytics.
Requirements for Using HubSpot Table Formatting
Before you start, confirm that your report and fields are compatible with conditional formatting in HubSpot.
Supported Report Types in HubSpot
You can apply conditional formatting to tables in:
- Single-object reports (for example: Contacts, Companies, Deals, Tickets)
- Cross-object reports that include multiple CRM objects
- Custom report builder reports with a table as the selected visualization
Other visualization types such as charts or dashboards do not support these specific table formatting rules.
Supported Field Types in HubSpot Tables
Not every column in a table can be formatted. Conditional formatting in HubSpot works with specific field types, including:
- Number fields (e.g., amounts, counts, percentages)
- Date fields that can be converted to numeric values for certain rules
- Calculated or aggregated fields (such as sums, averages, minimums, maximums) when they return numeric values
Text fields, boolean values, and select fields typically cannot use numeric-style rules, so they may not be available for conditional formatting.
How to Add Conditional Formatting in HubSpot
Once you have a suitable report and table, you can enable conditional formatting directly from the report builder.
Step 1: Open Your HubSpot Report
- In your HubSpot account, navigate to the main navigation menu.
- Go to Reports > Reports.
- Locate the custom report you want to edit.
- Click the report name to open it, then select Edit if you are not already in the builder.
Make sure the current visualization is set to a table view so that formatting options are available.
Step 2: Switch to a Table Visualization in HubSpot
- Inside the report builder, open the Configure or Visualization tab, depending on your interface.
- Select the Table visualization type.
- Confirm that the data you want to format appears as columns in the table.
If the right columns are missing, add or adjust fields in the Data tab before applying formatting.
Step 3: Open Conditional Formatting Settings
- Within the table visualization settings, locate the section labeled Conditional formatting.
- Click Add rule or a similar button to begin creating your first conditional formatting rule.
Each rule controls how one column in your HubSpot table will be colored based on its values.
Step 4: Choose the Column to Format
- Under the new rule, open the column dropdown.
- Select the numeric field you want to format, such as:
- Deal amount
- Ticket response time
- Email open rate
- Number of sessions or page views
If a column is not available, verify that it is numeric and already included in the table visualization.
Step 5: Define the Condition for Your HubSpot Rule
Next, configure the logic that decides when formatting will be applied. Common condition types include:
- Is greater than a value
- Is less than a value
- Is between two numeric values
- Is equal to or is not equal to a value
For example, you might define:
- Highlight deals where Amount is greater than 10000
- Flag tickets where Time to close is greater than 48 hours
- Color sessions where Bounce rate is between 70 and 100
Enter the appropriate numeric thresholds in the rule fields.
Step 6: Select Colors and Styles in HubSpot
Once the condition is in place, choose how cells should look when the rule is triggered.
You can typically configure:
- Background color of the cell
- Text color for the value
- Optional gradients or multiple colors for ranges, depending on the interface
Use consistent colors across your HubSpot reports, for example:
- Green for high performance or positive results
- Yellow or orange for moderate performance
- Red for low performance or at-risk values
This consistency will help your team interpret data quickly across dashboards and reports.
Step 7: Add More Rules for the Same Column
You can layer multiple rules on a single column in HubSpot to create ranges. For example:
- Rule 1: Amount is less than 5000 → red background
- Rule 2: Amount is between 5000 and 15000 → yellow background
- Rule 3: Amount is greater than or equal to 15000 → green background
Arrange the rules in the order you want them to be evaluated. If two rules overlap, HubSpot will typically apply the first matching rule, so ordering matters.
Editing and Managing HubSpot Conditional Formatting Rules
After your report is saved, you can always return to fine-tune or remove formatting rules as your reporting needs evolve.
How to Edit Existing Rules
- Open the report in the HubSpot builder.
- Go to the table visualization panel.
- In the Conditional formatting section, locate the rule you want to update.
- Click the rule to adjust the column, conditions, or colors.
- Apply your changes and save the report.
This is helpful when thresholds change, for example adjusting revenue targets or support response-time goals.
How to Reorder Rules in HubSpot
If multiple rules apply to one column, reorder them to control which rule wins.
- In the rule list, use the drag handle or directional arrows (if available) to move a rule up or down.
- Place the most specific or most important rules at the top.
- Save the report so new order takes effect for all viewers.
This ensures your HubSpot table shows the correct colors, especially when values satisfy more than one condition.
How to Delete Unneeded Rules
- Open the conditional formatting section of your table.
- Find the rule that is no longer needed.
- Click the trash icon or Delete option next to that rule.
- Confirm deletion and save the report.
Removing outdated rules keeps your HubSpot reports clean and easier for other users to understand.
Best Practices for HubSpot Table Formatting
To keep your reporting consistent and easy to read, follow these best practices when using conditional formatting in HubSpot.
- Limit the number of colors: Too many colors can confuse viewers. Stick to a simple palette.
- Use consistent meaning: For example, always use green for good and red for poor performance.
- Align rules with goals: Set thresholds that reflect your team’s KPIs, SLAs, or targets.
- Test with sample data: Preview the report with real data to ensure rules behave as expected.
- Document your legend: Add notes in dashboard descriptions or training docs so everyone understands what each color means in HubSpot.
Additional Resources
For the original product documentation and the most current behavior of conditional formatting, refer to the official HubSpot knowledge base article: Add conditional formatting to tables in reporting.
If you want expert help designing scalable reporting strategies, you can explore consulting services at Consultevo, which focuses on data, analytics, and CRM optimization.
By carefully configuring conditional formatting rules in your HubSpot table reports, you turn raw metrics into clear visual insights that help your team take faster, more informed action.
Need Help With Hubspot?
If you want expert help building, automating, or scaling your Hubspot , work with ConsultEvo, a team who has a decade of Hubspot experience.
“`
