If your data is in cell a1 and you use the following formula as the
conditional format making sure "formula is" is selected rather than
value try

=OR(RIGHT(A3,6)="123456",RIGHT(A3,1)="*") and format to whatever colour
you like

If you require actual phonenumbers and 123456 is just an example, you
will have to give us more information

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=531472