Submitted by carloscadu on 2022/03/25 09:02

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:
 
[ItemTags] contains ("1now" and "2soon") 
Just item "Test C" should be highlighted red.
 
[ItemTags] contains ("1now" or "2soon") 
Items "Test A", "Test B", "Test C" should be highlighted red. 
Item "Test D" shouldn't be highlighted at all, since it is out of any condition.
 
What could be going wrong?
 
Thank you,
Carlos

 

InfoQube_conditional AND OR

Comments

How do I ?