# Conditional color formatting of cells in tables to represent events that are occurring in the next x minutes or hours

**URL:** <https://forums.knack.com/t/conditional-color-formatting-of-cells-in-tables-to-represent-events-that-are-occurring-in-the-next-x-minutes-or-hours/5825>\
**Category:** Feature Requests\
**Created:** [October 7, 2015, 10:35pm UTC](https://forums.knack.com/t/conditional-color-formatting-of-cells-in-tables-to-represent-events-that-are-occurring-in-the-next-x-minutes-or-hours/5825 "2015-10-07T22:35:00Z")\
**Posts on this page:** 2\
**Page:** 1

<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 7, 2015, 10:35pm UTC](https://forums.knack.com/t/conditional-color-formatting-of-cells-in-tables-to-represent-events-that-are-occurring-in-the-next-x-minutes-or-hours/5825/1 "2015-10-07T22:35:00Z")

</div>

Having implemented tables to display a list of events, I have a requirement to show and color-code my events based on these rules:

  
- Yellow-colored event when it is due in the next 30 minutes.
  
- Red-colored event when it is overdue by 30 minutes or more.  
  
  

Following Knack's implementation of [conditional color formatting of table cells](http://helpdesk.knackhq.com/support/discussions/topics/5000008976), I would like to request Knack to allow hours and minutes to be used as unit of measures in the display rules. Currently, I can configure display rules down to weeks and days, not hours and minutes.

---

<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:** [July 15, 2021, 8:03pm UTC](https://forums.knack.com/t/conditional-color-formatting-of-cells-in-tables-to-represent-events-that-are-occurring-in-the-next-x-minutes-or-hours/5825/2 "2021-07-15T20:03:16Z")

</div>