Conditional formatting does not appear to be working correctlyl
I set conditional formatting to turn a row red if the due date is past; however, today is 3/5 and an item was due on 3/4 and it is not red. Other items due on 3/3 are red. I do have another rule that says to turn it purple if it is in the next 3 days. The row is purple, not red.
I also move the items around thinking it was something related to precedence. That didn't seem to change the value