Use of "and" and "or" in conditional formatting for [ItemTags] contains ("A" and "B")
Hi, I'd appreciate your help.
I tested two different conditional formatting for the main "Item" field (ID 1).
I expected the background color becoming RED (BackColor=&H0000FF).
[ItemTags] contains ("1now" and "2soon")
[ItemTags] contains ("1now" or "2soon")
Something is wrong with the syntax, since all items are becoming RED, as shown in the screen-recording below.
Instead, I'd expect the following output according to each syntax: