D
Domenic
Assuming that A2
4 contains the data, try...
1) Select B2
2) Format > Conditional Formatting > Formula Is
If the relevant information for Column B is always the last 3 characters:
=MATCH(RIGHT($B2,3)+0,$D$2:$D$4,0)
Otherwise:
=LOOKUP(9.99999999999999E+307,FIND($D$2:$D$4,$B2))
3) Choose 'Format'
4) Select the desired formatting
5) Click Ok twice
6) Copy the formatting to the other cells...
Copy > Paste Special > Formats
or
Format Painter
4 contains the data, try...1) Select B2
2) Format > Conditional Formatting > Formula Is
If the relevant information for Column B is always the last 3 characters:
=MATCH(RIGHT($B2,3)+0,$D$2:$D$4,0)
Otherwise:
=LOOKUP(9.99999999999999E+307,FIND($D$2:$D$4,$B2))
3) Choose 'Format'
4) Select the desired formatting
5) Click Ok twice
6) Copy the formatting to the other cells...
Copy > Paste Special > Formats
or
Format Painter