auto fill data in one cell based on formatting of another cell

[ashouse]

On my spreadsheet I will be highlighting cells in one column, as I highlight I want a corresponding cell in that row to populate with an amount from another cell in that row.

So column O will copy the amount in Column N only when Column D is highlighted in yellow.

Is this possible?

Thanks,
Amber