# How do I apply formatting to a table with grouped columns and rows?

**URL:** <https://connect.superhuman.com/t/how-do-i-apply-formatting-to-a-table-with-grouped-columns-and-rows/44567>\
**Category:** Ask the Community\
**Created:** [November 18, 2023, 5:30pm UTC](https://connect.superhuman.com/t/how-do-i-apply-formatting-to-a-table-with-grouped-columns-and-rows/44567 "2023-11-18T17:30:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fanda\_H](https://avatars.discourse-cdn.com/v4/letter/f/db5fbb/32.png) [@Fanda\_H](https://connect.superhuman.com/u/Fanda_H)\
**Post date:** [November 18, 2023, 5:30pm UTC](https://connect.superhuman.com/t/how-do-i-apply-formatting-to-a-table-with-grouped-columns-and-rows/44567/1 "2023-11-18T17:30:58Z")

</div>

Hello! I have a table of transactions and they’re grouped vertically by month and horizontally by category. I’d like to:

1. Apply zebra striping to the table so it’s easier to read when I have more grouped rows and grouped columns.
2. Apply conditional formatting so I can colour-code the highs and lows of each column and row.

Sample Coda doc here  
https://coda.io/embed/WaSSLbr8qI?viewMode=embed

---

<div class="post-metadata">

**Author:** ![Dan\_Demers](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/dan_demers/32/24226_2.png) [@Dan\_Demers](https://connect.superhuman.com/u/Dan_Demers)\
**Post date:** [November 23, 2023, 12:28am UTC](https://connect.superhuman.com/t/how-do-i-apply-formatting-to-a-table-with-grouped-columns-and-rows/44567/2 "2023-11-23T00:28:16Z")

</div>

Hey @Fanda_H,

Here is a great post from the community on this!

[Row color by color.](https://connect.superhuman.com/t/row-color-by-color-picker-in-each-row/18684)

There are some additional posts in the community that go over changing color and using conditional formatting. The basic way to do this would be to create a column with a simple checkbox that when select will apply coloring to a row.

Hope those options help!

Best,  
Dan

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [February 21, 2024, 12:28am UTC](https://connect.superhuman.com/t/how-do-i-apply-formatting-to-a-table-with-grouped-columns-and-rows/44567/3 "2024-02-21T00:28:55Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
