Using the and function in conditional formatting

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 :wink: ?

Because the use of A AND B works for conditionnal formating, as well as AND(a,b,c,d,e,...)

Not Working :

Working :


It works, thank you very much!

1 Like

be my guest, do not hesitate to reach out if you have any additional issue. I let you mark the post as solved :wink: