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
Comments
I haven't tested, but try: …
I haven't tested, but try:
[ItemTags] contains "1now"…
It worked. Thank you!
Great ! I noticed your font…
Great !
I noticed your font is Segeo UI. For an improved render and contrast, I recommend switching to Segoe UI Variable Display. In is pre-installed on Windows 11 (your current OS). The result is impressive !
Details here: Settings for best IQ experience
I noticed your font is…
Thanks for the tip. Done and impressive indeed 👍