# Conditional Colour formatting of cells in tables

**URL:** <https://forums.knack.com/t/conditional-colour-formatting-of-cells-in-tables/5483>\
**Category:** Feature Requests\
**Created:** [November 19, 2014, 1:30am UTC](https://forums.knack.com/t/conditional-colour-formatting-of-cells-in-tables/5483 "2014-11-19T01:30:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![AdrianBell27622](https://avatars.discourse-cdn.com/v4/letter/a/f6c823/32.png) [@AdrianBell27622](https://forums.knack.com/u/AdrianBell27622)\
**Post date:** [November 19, 2014, 1:30am UTC](https://forums.knack.com/t/conditional-colour-formatting-of-cells-in-tables/5483/1 "2014-11-19T01:30:00Z")

</div>

I’d really like an easy way to conditionally format the values of a field in table (Similar to Excel).  
If Field A Value = High; Colour of Field A cell in table displayed is RED   
If Field A Value = Med; Colour of Field A cell in table displayed is YELLOW  
If Field A Value = Low; Colour of Field A cell in table displayed is BLUE OR If Field B Value \> 50; Colour of Field C cell in table displayed is RED  
If Field B Value is 11-50; Colour of Field C cell in table displayed is ORANGE  
If Field B Value \< 11; Colour of Field C cell in table displayed is GREEN

---

<div class="post-metadata">

**Author:** ![DanielYoun21557](https://avatars.discourse-cdn.com/v4/letter/d/c37758/32.png) [@DanielYoun21557](https://forums.knack.com/u/DanielYoun21557)\
**Post date:** [October 8, 2015, 10:28pm UTC](https://forums.knack.com/t/conditional-colour-formatting-of-cells-in-tables/5483/2 "2015-10-08T22:28:42Z")

</div>

Hi,

I also notice the align is only for the cells not the header, need both or to control both with the one option.

Thanks

Dan

---

<div class="post-metadata">

**Author:** ![AdrianBell27622](https://avatars.discourse-cdn.com/v4/letter/a/f6c823/32.png) [@AdrianBell27622](https://forums.knack.com/u/AdrianBell27622)\
**Post date:** [October 5, 2015, 11:25pm UTC](https://forums.knack.com/t/conditional-colour-formatting-of-cells-in-tables/5483/3 "2015-10-05T23:25:16Z")

</div>

Terrific news. Thank-you!

---

<div class="post-metadata">

**Author:** ![TommyTze31335](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/tommytze31335/32/165_2.png) [@TommyTze31335](https://forums.knack.com/u/TommyTze31335)\
**Post date:** [October 5, 2015, 10:47pm UTC](https://forums.knack.com/t/conditional-colour-formatting-of-cells-in-tables/5483/4 "2015-10-05T22:47:15Z")

</div>

Hi all,  
  
It looks like Knack has just delivered this feature today, which is great! See [http://www.knackhq.com/links/blogs/table-options.html](http://www.knackhq.com/links/blogs/table-options.html)  
  
Following this newly delivered feature, I would like to request Knack to further enhance the date/time display rule to allow rules down to the hour. For example, I would like cells to be colored red when the scheduled date/time on affected records are set to occur during the next 1 hour. Currently, the rule only goes down to “during the next 1 day”.

---

<div class="post-metadata">

**Author:** ![Jessie](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/jessie/32/5_2.png) [@Jessie](https://forums.knack.com/u/Jessie)\
**Post date:** [August 4, 2021, 1:18pm UTC](https://forums.knack.com/t/conditional-colour-formatting-of-cells-in-tables/5483/5 "2021-08-04T13:18:43Z")

</div>