Setting colour based on date (time elapsed)

[Mudassar_Aziz]

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?

[Elias_Gomez_Sai]

You have this for Pro plans:

Airtable - Support

Record coloring

Record coloring is a Pro plan feature that allows you to color-code your records—meaning that you can quickly discern meaningful distinctions between records more easily, without having to dig into...

The free alternative is this:

Airtable - Support

Conditional formulas with emoji

Incorporating colorful emoji into conditional (IF) statements in a formula field is a great way to automatically flag records meeting certain conditions. If you have Windows 10, you can bring up an...

[Mudassar_Aziz]

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.

[Elias_Gomez_Sai]

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