• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Highlighting Items Past Today

Emma F

New Member
efc67d42-71b9-4324-8de0-fdfa309f74c2
Hi
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="")

upload_2017-6-27_15-8-0.png
 

Attachments

  • upload_2017-6-27_15-2-16.png
    upload_2017-6-27_15-2-16.png
    39.7 KB · Views: 1
Back
Top