Hi all

I have a worksheet consisting of numerous telephone numbers - some are
business and some are private. I have to find all those numbers which are
private and highlight them.

I realise that Excel won't be able to identify what is work and what is
private so I could enter a code beside each cell that is a work number, thus
the rest must be privat.e If i did it this way, how would I ask Excel to
highlight all those cells that are private numbers?

Hope this makes sense.........

Thank you.

Louise