| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
colour cells, same numbers different worksheets
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
colour cells, same numbers different worksheets
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 "geenie" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem printing all worksheets in colour | Excel Discussion (Misc queries) | |||
| Changing all cells in one colour to a different colour | Excel Discussion (Misc queries) | |||
| Help Please.....numbers reaching limits and cells changing colour | Excel Worksheet Functions | |||
| Adding numbers in cells based on colour | Excel Worksheet Functions | |||
| Colour Printing with Multiple Worksheets | Excel Discussion (Misc queries) | |||
Linear Mode
