# Conditional formatting: totals values + dynamic ranges

**URL:** https://community.holistics.io/t/conditional-formatting-totals-values-dynamic-ranges/700
**Category:** Feature Suggestions
**Tags:** visualizations
**Created:** [January 31, 2022, 8:54pm UTC](https://community.holistics.io/t/conditional-formatting-totals-values-dynamic-ranges/700 "2022-01-31T20:54:15Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![Alex\_H](https://community.holistics.io/user_avatar/community.holistics.io/alex_h/32/357_2.png) [@Alex\_H](https://community.holistics.io/u/Alex_H)
#### Post date: [January 31, 2022, 8:54pm UTC](https://community.holistics.io/t/conditional-formatting-totals-values-dynamic-ranges/700/1 "2022-01-31T20:54:15Z")

</div>

Currently in a cross-tab, total values on Rows/Sums are excluded from formatting, would be good to include the option.

Also, currently scale formatting is restricted to hard-coded values. It would be great to be able to enable a dynamic range (e.g. min, median, max).

---

<div class="post-metadata">

### Author: ![di.hoang](https://community.holistics.io/user_avatar/community.holistics.io/di.hoang/32/421_2.png) [@di.hoang](https://community.holistics.io/u/di.hoang)
#### Post date: [February 7, 2022, 8:08am UTC](https://community.holistics.io/t/conditional-formatting-totals-values-dynamic-ranges/700/2 "2022-02-07T08:08:52Z")

</div>

Thanks for your suggestion @Alex_H

We are planning to support Conditional Formatting for Total Values, and expect to release it soon in the next few weeks. Will drop you a message when it’s done!

For the CF dynamic range, would you mind sharing with us more detailed on your case?

---

<div class="post-metadata">

### Author: ![di.hoang](https://community.holistics.io/user_avatar/community.holistics.io/di.hoang/32/421_2.png) [@di.hoang](https://community.holistics.io/u/di.hoang)
#### Post date: [October 15, 2024, 10:27am UTC](https://community.holistics.io/t/conditional-formatting-totals-values-dynamic-ranges/700/3 "2024-10-15T10:27:43Z")

</div>

4 posts were merged into an existing topic: [Dynamic Conditional Formatting](https://community.holistics.io/t/dynamic-conditional-formatting/794)

---

<div class="post-metadata">

### Author: ![di.hoang](https://community.holistics.io/user_avatar/community.holistics.io/di.hoang/32/421_2.png) [@di.hoang](https://community.holistics.io/u/di.hoang)
#### Post date: [February 7, 2022, 9:55am UTC](https://community.holistics.io/t/conditional-formatting-totals-values-dynamic-ranges/700/4 "2022-02-07T09:55:25Z")

</div>

Got your case! Thank you for sharing @Alex_H  
We’ll add the dynamic CF to our backlog and will let you know if we have any plan to support it in the future. Thank you for your patience and understanding!

---

<div class="post-metadata">

### Author: ![di.hoang](https://community.holistics.io/user_avatar/community.holistics.io/di.hoang/32/421_2.png) [@di.hoang](https://community.holistics.io/u/di.hoang)
#### Post date: [February 14, 2022, 9:03am UTC](https://community.holistics.io/t/conditional-formatting-totals-values-dynamic-ranges/700/5 "2022-02-14T09:03:40Z")

</div>

Hi @Alex_H Glad to let you know that now you can apply the Conditional Formatting for total values. Don’t hesitate to drop us a message if you encounter any issues with it 😊

---

<div class="post-metadata">

### Author: ![di.hoang](https://community.holistics.io/user_avatar/community.holistics.io/di.hoang/32/421_2.png) [@di.hoang](https://community.holistics.io/u/di.hoang)
#### Post date: [October 15, 2024, 10:26am UTC](https://community.holistics.io/t/conditional-formatting-totals-values-dynamic-ranges/700/8 "2024-10-15T10:26:31Z")

</div>

Hi @Alex_H @olammas @georgek,

It looks like this request is similar to the [Dynamic Conditional Formatting - Feature Suggestions](https://community.holistics.io/t/dynamic-conditional-formatting/794)

To keep things organized, we’ll move your request to that discussion and close this topic. Thanks for your understanding!

Feel free to join the conversation there! 😊

---

<div class="post-metadata">

### Author: ![di.hoang](https://community.holistics.io/user_avatar/community.holistics.io/di.hoang/32/421_2.png) [@di.hoang](https://community.holistics.io/u/di.hoang)
#### Post date: [October 15, 2024, 10:36am UTC](https://community.holistics.io/t/conditional-formatting-totals-values-dynamic-ranges/700/9 "2024-10-15T10:36:39Z")

</div>


