This would definitely be nice to have. Here’s the use case I have.
In my Health tracker doc each component of a meal has a calcium value:
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:
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. 