Skip to main content

Setting colour based on date (time elapsed)

  • December 6, 2018
  • 3 replies
  • 116 views

Hi All

I just started using Airtable and have replicated my sales pipeline from excel. I’m really happy with how well I have copied across.

I want to add something which I don’t currently use, which is that I wanted each row to auto turn red if the date column has a date which is older than 10 days to the current date.

Is this possible? Especially without having to have another column just to add todays date?

This topic has been closed for replies.

3 replies

Forum|alt.badge.img+17

You have this for Pro plans:

The free alternative is this:


  • Author
  • New Participant
  • December 8, 2018

Thanks for the links but I have already read them both. I can’t though see how I can use the functions to enable the colour recording.


Forum|alt.badge.img+17

Thanks for the links but I have already read them both. I can’t though see how I can use the functions to enable the colour recording.


Why? It’s explained in the article, in the “Record coloring by conditions” section.