# Conditional formatting for % data in reports

**URL:** <https://community.hubspot.com/t/conditional-formatting-for-data-in-reports/126371>\
**Category:** HubSpot Ideas\
**Tags:** reports\
**Created:** [February 19, 2025, 10:35am UTC](https://community.hubspot.com/t/conditional-formatting-for-data-in-reports/126371 "2025-02-19T10:35:25Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Stevie-Kv](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/stevie-kv/32/97206_2.png) [@Stevie-Kv](https://community.hubspot.com/u/Stevie-Kv)\
**Post date:** [February 19, 2025, 10:35am UTC](https://community.hubspot.com/t/conditional-formatting-for-data-in-reports/126371/1 "2025-02-19T10:35:25Z")

</div>

**Context**

- Hubspot’s table reports allow for conditional formatting to be applied
  - [Add conditional formatting to tables in reporting](https://knowledge.hubspot.com/reports/add-conditional-formatting-to-tables-in-reporting)

- Min and Max is set automatically by default, but you can give it a set numerical value if needed

**Challenge**

- You cannot currently add a “.” to the Min and Max fields when setting up the conditional formatting.
- This prevents you from applying conditional formatting to % values, which display numerically as 0 - 1.
- For example, “Marketing Email Delivery Rate”
  - I want to set the max to 1 (100%)
  - I want to set the min to 0.95 (95%)

**Idea**

- Let us put decimals into the min and max fields in the report builder! 😀

Note: A less than ideal workaround is to build a dataset and create a calculation to multiply the rate by 100, turning 0-1 into 0-100.