I have a spreadsheet of dialled telephone number in various formats eg
"01234123456", or "00441234123456", and am trying to highlight their personal
calls using conditional formatting.

I am looking for a formula that says highlight this cell if this cell
CONTAINS "123456" ie that last six digits of the number. Some people do
however use a * at the end of the number dialled to indicate a personal call
but they are not consistent! e.g 01234123456* or 00441234123456*

Any ideas?