Can some one please help me with a conditional formatting formula

Looking at the table below - I need to set up the conditional formatting so
when the "Current position" column has "N" the name goes red. when the
"Current position" column is NOT equal to the contents in the "Targeted
position" column the name goes Amber... and when the "Current position"
column is equal to the contents in the "Targeted position" column the name
goes Green

Influence Current position Targeted
position
First Name Surname High
Medium
Low Positive
Impartial
Negative Positive
Impartial
Negative
red
Amber
Green N
not = to target
Is =to target

John Smith H P P



Thank you