I did actualy try this but couldn't get it to work exactly as I want it to
but don't know if I'm asking for too much.

If I have the word 'private' in a cell A1 and the actual telephone number in
B1, how can I ask it to highlight 'private' AND the number in column B if the
criteria is met?

I have got it to highlight the cells containing the text in column A, but
is there any way of extending the highlight to the actual number next door,
so I don't have to do it myself?

Hope this makes sense.

"CLR" wrote:

Format ConditionalFormat and follow the menus......this feature cancolor
the background of cells, change the font color and/or add borders to cells,
depending on your conditions........give it a try and post back with the
details if you run into problems.

Vaya con Dios,
Chuck, CABGx3



"Louise" wrote:

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