How do I add a conditional format based on current date?

Hello all,

I have a list of dates of events. I’m trying to put conditionals that will changed based on close we’re getting to that date. Is this possible?

Example: there is an event 2 weeks out. As we approach that date, the cell will becoming redder and redder.

Hi @Peter_Lee,

You can create a field that calculates the number of days between the event date and the current date (use the now function to get the current date), and apply conditional formatting based on that calculated field.