Conditional Checkin date color with Format Rules

[rajivvaishnav]

Hey,

I have a booking app, and it has a checkin date, now in slice view and Main view, I wish to show 3 different colors for checkin date, if the date is 10 days from today then it must be green color, if its 5 days then orange color and if its 3 days then it must be red color how can I do that?

regards

Rajiv

[Suvrutt_Gurjar · Accepted solution]

You will need 3 format rules , with expressions something like below. You may need minor adjustments depending on your precise requirements. For example 10 days away - does it mean 5 to 10 days or more than 10 days away? The below suggestion is for 5 to 10 days away for green color.

1. Green color

AND([Checkin Date]> TODAY()+5 , [Checkin Date]<=TODAY()+10) 

2. Orange color 

AND([Checkin Date]> TODAY()+3 , [Checkin Date]<=TODAY()+5) 

3. Red color

[Checkin Date] <=TODAY()+3