# Conditional Formatting on Summary Lines

**URL:** <https://connect.superhuman.com/t/conditional-formatting-on-summary-lines/12782>\
**Category:** Ask the Community\
**Created:** [December 14, 2019, 4:48am UTC](https://connect.superhuman.com/t/conditional-formatting-on-summary-lines/12782 "2019-12-14T04:48:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Laurent\_Ades](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/laurent_ades/32/11296_2.png) [@Laurent\_Ades](https://connect.superhuman.com/u/Laurent_Ades)\
**Post date:** [December 14, 2019, 4:48am UTC](https://connect.superhuman.com/t/conditional-formatting-on-summary-lines/12782/1 "2019-12-14T04:48:18Z")

</div>

Hi,

I am applying conditional formatting to a table with summary lines.  
It appears to be working well on individual data lines as per the conditions i am setting but never applies to the summary lines and i cannot seem to find a toggle type of option which would extend conditions criteria and styling to these…  
Is it not yet a feature or am i looking in the wrong place ?  
Thanks

---

<div class="post-metadata">

**Author:** ![Paul\_Danyliuk](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/paul_danyliuk/32/27228_2.png) [@Paul\_Danyliuk](https://connect.superhuman.com/u/Paul_Danyliuk)\
**Post date:** [December 14, 2019, 12:49pm UTC](https://connect.superhuman.com/t/conditional-formatting-on-summary-lines/12782/3 "2019-12-14T12:49:01Z")

</div>

I don’t think you can format summaries.

What you can do instead is make a separate table where you’ll aggregate the data you need into cells, and conditionally format those. Sure, not as convenient, but it’s something.

---

<div class="post-metadata">

**Author:** ![Eduardo\_Cavazos](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/eduardo_cavazos/32/14044_2.png) [@Eduardo\_Cavazos](https://connect.superhuman.com/u/Eduardo_Cavazos)\
**Post date:** [April 26, 2020, 5:45am UTC](https://connect.superhuman.com/t/conditional-formatting-on-summary-lines/12782/4 "2020-04-26T05:45:19Z")

</div>

This would definitely be nice to have. Here’s the use case I have.

In my [Health tracker doc](https://connect.superhuman.com/t/coda-health-tracker/15212) each component of a meal has a calcium value:

 ![image](https://global.discourse-cdn.com/coda1/original/2X/5/550c28c7c2cb3f98a0c58d92c3db249b24f0d651.png)

I can of course set up conditional formatting for these cells. However, I’m not so much interested in individual food calcium values. I’m instead, more interested in hitting a goal value for the day (e.g. 1000 for the day).

If I collapse that day, we see that the total calcium for that day is 1041:

 ![image](https://global.discourse-cdn.com/coda1/original/2X/c/c72082b504d7a94035ef19e1754f64e33bb28cdb.png)

Since it’s above 1000, it would be nice to format it as ‘green’, for example, to indicate that the daily goal was met.

As far as I know, this is not yet possible.

Coda team: please consider adding this feature. 🙂
