A tricky Conditional Formatting question...

Hi people

I have a slightly complicated question.

Data:
excel question.PNG



I would like to have a conditional formatting that determines in below order:
1. If Settled? column = N...
2. Check if Due Date is older than today
3. Highlight the cell in Due Date in Red if it is older than today
4. Do nothing if its not today but settled = N (donno if this step is done automatically?)

---If Settled? column = Y
1. Just highlight both cell Green


And I would like to format the whole column at the same time, wondering if the conditional formatting can do them all at the same time, because I am unsure if there's a function to determine 'if the cell on the right'

Thank you!