Conditional Formatting: Change color next column

[sammipd]

I used Conditional Formatting to color code the Task List by Due Date (overdue, last week, this week, next week). How can I use it to remove the colors when any text is placed in the Completed column?

<tbody>
</tbody>

Completed	Due	TASK
	10/7/2017	data
	10/24/2017	data
	10/24/2017	data
	11/1/2017	data
	11/2/2017	data
	11/3/2017	comm
	11/7/2017	data
	11/8/2017	data
	11/8/2017	data
10/4/2017	10/4/2017	misc
10/5/2017	10/5/2017	data
10/10/2017	10/6/2017	data
10/5/2017	10/6/2017	data

<tbody>
</tbody>

 

[Joe4]

Amend your current Conditional Formatting to check for a value in that column.
So, if your Completed Column is column A, the CF might look something like:

=AND(A2="",[I]current formula[/I])

 

[Scott T]

Select the due date cells and use this formula where A2 is the completed column, adjust to match your data. Do not select any format

=LEN(A2)>0

In the rules manager move the rule you just created above the rule to format the due date and click stop if true.

 

[sammipd]

Thank you Scott T. Just what I needed!