How to Change Text Color of Public Holidays

AppSheet AppSheet Q&A
,
1

I would like to change the text color of public holidays on my app.

I tried to use “Format rules” feature and set the condition below.

IN([date] = 
  {"the list of public holidays"}
)

but an error message appeared, “Cannot compare Date with List in~” .

Anybody knows how to fix it or more smart way?

2

Review the syntax of the [IN](AppSheet function list - AppSheet Help function. Replace = with ,.

2 Likes
3

Thanks dbaum,

I made a silly mistake. That works correctly.