|
Help with conditional formatting
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 |
Help with conditional formatting
formulae of
=B2="N" =B2<C2 =B2=C2 -- __________________________________ HTH Bob "Stig - tame racing driver" wrote in message ... 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 |
Help with conditional formatting
Cheers,
I should of fig that one out Do'H "Bob Phillips" wrote in message ... formulae of =B2="N" =B2<C2 =B2=C2 -- __________________________________ HTH Bob "Stig - tame racing driver" wrote in message ... 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 |
| All times are GMT +1. The time now is 03:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com