Highlight cell if date has passed

[DTbox]

I know this seems simple but I've been researching this for a few hours and I'm come up blank. I'm looking to do the following two things with conditional formatting.

1. I need a cell in Row B to go RED if the planned end date has passed and YELLOW if the planned end date is within 14 days of the date in the cell.
2. Regardless of the date in Row B, if the status shows CLOSED in Row C, the cell in Row B goes back to normal, not showing a color.

Everything I've read online shows me how to do this based on todays date only. I don't want that. I need it based off the date in the Row B. Any help would be much appreciated.

 

[DTbox]

I understand the CF doesn't copy from the XL2BB so you won't be able to copy the format. In any event, look at post #18. They are the formulas to use. "OPEN" is never in column F, it's in column H.

Works perfectly. Thank you for being patient. Appreciate the help.

 

[kevin9999]

Works perfectly.

Glad we got there in the end