How to copy formatting from one list to another?

B

bxcfilm

We have a large database (Excel spreadsheet about 16,000 rows). One
person is going through it, checking against other information. When a
row is checked, he is showing that by formatting the figure in column B
in red.

This is a very long task, so we want to put another person on to it,
using a copy of the spreadsheet. However, the problem comes when the
job is finished. How do we combine the two sets of results?

The underlying data in the spreadsheet is not being changed in this
exercise, only the format colour.

So we will end up with two copies of the spreadsheet, one with certain
cells in Column B coloured red, and another copy with DIFFERENT cells
in Column B coloured red. Is there a way of combining the two lists
into a final list, so that all the cells which are red in either
original list are red in the final list?
 
J

Jim Rech

I'd suggest a leg irons and a whip. Neither worker leaves until he's done
his half!

Alternatively, perhaps a macro. This requires both workbooks to be open in
the same instance of Excel. Adjust the workbook names.

Sub MergeColors()
Dim WS1 As Worksheet
Dim WS2 As Worksheet
Dim Cell As Range
Set WS1 = Workbooks("Book1.xls").ActiveSheet
Set WS2 = Workbooks("Book2.xls").ActiveSheet
For Each Cell In WS1.Columns(2).SpecialCells(xlCellTypeConstants)
If Cell.Font.ColorIndex = 3 Then
WS2.Range(Cell.Address).Font.ColorIndex = 3
End If
Next
End Sub


--
Jim Rech
Excel MVP
| We have a large database (Excel spreadsheet about 16,000 rows). One
| person is going through it, checking against other information. When a
| row is checked, he is showing that by formatting the figure in column B
| in red.
|
| This is a very long task, so we want to put another person on to it,
| using a copy of the spreadsheet. However, the problem comes when the
| job is finished. How do we combine the two sets of results?
|
| The underlying data in the spreadsheet is not being changed in this
| exercise, only the format colour.
|
| So we will end up with two copies of the spreadsheet, one with certain
| cells in Column B coloured red, and another copy with DIFFERENT cells
| in Column B coloured red. Is there a way of combining the two lists
| into a final list, so that all the cells which are red in either
| original list are red in the final list?
|
|
| ---
|
|
 
B

Brian

Many thanks for your code; I will amend it to suit. Interesting thought
about the leg irons and whip! However, considering the job is likely to take
months, rather than weeks, it MIGHT be seen as cruel and unusual punishment
<g>.

I'm now working on how to add up quickly how many cells have been dealt with
by each team member, so that I can keep track on how far they've got with
the job. This page looks interesting:

http://www.cpearson.com/excel/colors.htm
 
Top