Conditional Format Rules formula - Highlight colour in the specific time range

[helpdesk01]

I’m try to use AppSheet to show google calendar's schedule acts as a display board showing in-front of the meeting room

I’ve added Google Calendar as a data source, and added a table from Google Calendar with column [Start] schedule start time and [End] schedule end time both in "DateTime" format.

What is the formula if I want to highlight the current schedule with different colour

[WillowMobileSys]

i assume you are referring to displaying the Google Calendar events in an AppSheet Calendar View? 

If so, then you can assign a color to the Category property and the event will take on that color.  NOTE:  There is limit of 8 colors.

There is more info in this Feature Idea - while there Upvote it. 

https://www.googlecloudcommunity.com/gc/Feature-Ideas/Configuring-color-for-Calendar-display-categor...

[helpdesk01]

Thx, I know the colour category function. But I've no idea of the formula, how to highlight  event if it's in the current timeslot. 

Let's said if I've 3 event today, 11:00-12:00, 14:30-15:30, 16:00-18:00, if it's 11:05 then the event "11:00-12:00" will mark as Red. If it's 15:29 then the "14:30-15:30" event will marks as Red while other event use the default colour, and so on.

[Steve · Accepted solution]

Add a virtual column to the calendar table with an App formula like this:

IF(
  AND(
    (NOW() >= [Start]),
    (NOW() < [End])
  ),
  "Red",
  "Green"
)

[helpdesk01]

Hi Steve,

Thanks, that is the solution.  The formula looks simple, but it's complicate for me to reslove at the begining without the logic and concept. 

Shame