I'm tying to highlight uncompleted tasks prior to today in red (column b). Completed tasks have a "c" (in column c) and I have a formula that changes the task to green once I enter "c''. I have one column per day - date header is in Row 2. I've tried using the below formula in conditional formatting which works except it also highlights tasks in future days columns. How do I ignore this?
Thanks
=AND(B6<>"",C6<TODAY(),C6="")