S
Stig - tame racing driver
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
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