Prev: a cell contain formula, how to extract value of that cell
Next: how to delete recent cocuments
From: geenie on 23 Jan 2010 05:44
Hi, I need to colour cells that are the same number (10 digit cellphone
number) if this number appears on sheet 2 it must colour cell with the same
number in sheet one. If both sheets with the same number can be coloured.
They can all be one colour, the point would be to see what numbers are not on
both sheets.

I hope that makes sense. Thanks
From: Don Guillett on 23 Jan 2010 08:38
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"geenie" <geenie(a)discussions.microsoft.com> wrote in message
news:7324D685-A406-408D-8B60-9408FB64F376(a)microsoft.com...
> Hi, I need to colour cells that are the same number (10 digit cellphone
> number) if this number appears on sheet 2 it must colour cell with the
> same
> number in sheet one. If both sheets with the same number can be coloured.
> They can all be one colour, the point would be to see what numbers are not
> on
> both sheets.
>
> I hope that makes sense. Thanks

 | 
Pages: 1
Prev: a cell contain formula, how to extract value of that cell
Next: how to delete recent cocuments