How to Change Text Color of Public Holidays

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?

Solved Solved
0 2 111
1 ACCEPTED SOLUTION

Review the syntax of the IN function. Replace = with ,.

View solution in original post

2 REPLIES 2

Review the syntax of the IN function. Replace = with ,.

Thanks dbaum,

I made a silly mistake. That works correctly.

Top Labels in this Space