I cant seem to be able to use the “and” function in the formula field in conditional formatting. Is it that this feature hasnt been included yet, or am i doing the formula wrongly?
In my table below, the Due Date field is supposed be highlighted red if its past today, and also if its not been completed. It doesnt seem to be working though… not sure whats wrong.
I suggest it misses a .ToText() mention after your check about Status. Try to use
Status.ToText() to be sure that you compare to string ?
Because the use of
A AND B works for conditionnal formating, as well as
Not Working :
It works, thank you very much!
be my guest, do not hesitate to reach out if you have any additional issue. I let you mark the post as solved