Skip to main content

Hi all!


I think this would be super helpful to have programed as a default. "within (number of days) of date chosen, date will highlight as (choose color)



Short of that, is there a way to script this?



Thank you,


B

Hi @Barry,



welcome to Airtable community! This is possible but it is required to have a Pro plan in Airtable because the coloring option is in available on that plan.



Then you can create a formula field which will check the conditions of formatting. For example for 30 days before a date, the date has to be formatted:





IF(DATETIME_DIFF({your_date_field},now(),‘dasys’)<30,“red color”,“blue color”)





The next step is to set up a conditional formatting like the “red color” with the red color.



Please text us back if it works for you.



Thanks


Dimitris Goudis

Reply


Terms & Conditions