Conditional formatting and relative cell reference

[HunterTTP]

I have never used conditional formatting before today.

I have a list of assignments and due dates. I've applied conditional formatting to the due dates (column D) seen below

The only problem is that it is showing red for assignments that are already complete (column F) and I need it to just make those black/white as normal.

Here are a couple steps I looked at:

But to be honest, I have no idea what to put into the formula bar for the rule.

 

[AliGW]

You need four rules: one each for the four status messages. If the dates are in column D and the status messages in column F (starting row 3), then in D3 the first rule you needs is:

=D$3="Waiting"

and set the colour to whatever you want.

You then copy the conditional format down using the format painter, or you can simply set the correct cell range when you create each of the four rules.

 

[HunterTTP]

You need four rules: one each for the four status messages. If the dates are in column D and the status messages in column F (starting row 3), then in D3 the first rule you needs is:

=D$3="Waiting"

and set the colour to whatever you want.

You then copy the conditional format down using the format painter, or you can simply set the correct cell range when you create each of the four rules.

I don't think that is what I'm trying to do. I'm happy with the conditional formatting of Column F, I just want the Conditional formatting of Column D to be black text on white background if the status in Column F is "Complete".