# Conditional formatting for using relative time frame

**URL:** <https://community.omni.co/t/conditional-formatting-for-using-relative-time-frame/455>\
**Category:** Visualizations\
**Tags:** dashboards\
**Created:** [April 21, 2026, 8:46am UTC](https://community.omni.co/t/conditional-formatting-for-using-relative-time-frame/455 "2026-04-21T08:46:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![PB-S](https://avatars.discourse-cdn.com/v4/letter/p/ecccb3/32.png) [@PB-S](https://community.omni.co/u/PB-S)\
**Post date:** [April 21, 2026, 8:46am UTC](https://community.omni.co/t/conditional-formatting-for-using-relative-time-frame/455/1 "2026-04-21T08:46:35Z")

</div>

Hello everyone,

I would like to create conditional formatting to highlight the row where my date is over 60 days ago.  
It seems that I can only use a fixed date to do that.

Thanks in advance

---

<div class="post-metadata">

**Author:** ![colin](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.omni.co/colin/32/112_2.png) [@colin](https://community.omni.co/u/colin)\
**Post date:** [April 21, 2026, 2:23pm UTC](https://community.omni.co/t/conditional-formatting-for-using-relative-time-frame/455/2 "2026-04-21T14:23:39Z")

</div>

Can build a calc next door to time and use that for the logic (ie ask the calc AI for a yes/no for \>60 days ago and then key the formatting off that column).