Conditional Formatting: Selection from a drop down list and a date field change row color

[betheeem]

I have the attached spreadsheet that is tracking a project. I have used conditional formatting to do the following.

1) If status the task is marked Complete ($D2) the row text will strikeout and turn light gray
2) If projected due date ($C2) is coming in the next two weeks it change the row to yellow
3) If projected due date ($C2) is over due it will change the row to red

I would like to add the following but cannot get it to work.

1) I would like to change the row to orange if the projected start date ($B2) is today or past due and the task status still is marked Pending ($D2) *Status is a drop down list option.
a) this will proceed the yellow coding above
b) the row would stay red if the task status is In Progress and past due
2) Would like the row to change to another color if the task status is marked Complete ($D2) and the Actual completion Date ($E2) is blank

No matter what I try it will not work.

Any assistance would be helpful.

[FDibbins]

Hi, welcome to the forum

your 2nd rule has "" around it, remove that...
=$B2<TODAY()

[FDibbins]

Hi, welcome to the forum

your 2nd rule has "" around it, remove that...
=$B2<TODAY()

[betheeem]

Thank you for the welcome.

I would like to change the row to orange if the projected start date ($B2) is today or past due and the task status still is marked Pending ($D2) *Status is a drop down list option. (this will proceed the yellow coding above)

I tried this =AND($B2<=TODAY(),$D2<>"Pending") and it does not work properly the rows it highlight do not match the criteria. Thinking that it is drop down list related but the complete formatting works so I am baffled.

See attached updated spreadsheet. Row 132 highlights orange but the drop-down status is In Progress not Pending.

[betheeem]

I just saw my error and changed the conditional formatting above to

Please Login or Register  to view this content.