G
Guest
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
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