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.