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?
[TABLE="width: 219"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 219"]
<tbody>[TR]
[TD]Completed[/TD]
[TD]Due[/TD]
[TD]TASK[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]10/7/2017[/TD]
[TD]data[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]10/24/2017[/TD]
[TD]data[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]10/24/2017
[/TD]
[TD]data[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]11/1/2017[/TD]
[TD]data[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]11/2/2017[/TD]
[TD]data[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]11/3/2017[/TD]
[TD]comm[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]11/7/2017[/TD]
[TD]data[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]11/8/2017[/TD]
[TD]data[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]11/8/2017[/TD]
[TD]data[/TD]
[/TR]
[TR]
[TD]10/4/2017[/TD]
[TD]10/4/2017[/TD]
[TD]misc[/TD]
[/TR]
[TR]
[TD]10/5/2017[/TD]
[TD]10/5/2017[/TD]
[TD]data[/TD]
[/TR]
[TR]
[TD]10/10/2017[/TD]
[TD]10/6/2017[/TD]
[TD]data[/TD]
[/TR]
[TR]
[TD]10/5/2017[/TD]
[TD]10/6/2017[/TD]
[TD]data[/TD]
[/TR]
</tbody>[/TABLE]

 

[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!