I'n trying to work out a formula for Conditional Formatting a row to format the text BOLD if it contains a certain phrase or name within the cell.
So far i have made a list of the names i need, named the range "LG" and used the following code:
However, this is too specific, it only picks up exact matches, my criteria of names will change constantly but will always have the constants of RBS, RBOS or Natwest contained within the cell, is there an alternative to MATCH that i can use that is less specific?
Thanks
So far i have made a list of the names i need, named the range "LG" and used the following code:
Code:
=ISNUMBER(MATCH($A1,LG,0))
However, this is too specific, it only picks up exact matches, my criteria of names will change constantly but will always have the constants of RBS, RBOS or Natwest contained within the cell, is there an alternative to MATCH that i can use that is less specific?
Thanks