Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Comparing cells, coloring differences
Hopefully last question for a while -- I would like to compare
adjoining cells (B1 and C1, B2 and C2, etc.), and change the color of the C cells which are not identical to their B counterparts. It would save me an enormous amount of work, but unfortunately I'm not quite at the point where I can work this sort of thing out by myself. Any help would be greatly appreciated indeed! |
#3
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Comparing cells, coloring differences
Thanks Jay! Unfortunately I'm getting a compile bug. (Probably I'm
doing something silly, or using the wrong version of Excel: Office XP Professional, by the way.) The offending line is... Dim oTbl As Table .... and the error is ... Compile Error: User-defined type not defined. |
#4
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Comparing cells, coloring differences
On Mon, 3 Mar 2008 17:25:25 -0800 (PST), wrote:
Thanks Jay! Unfortunately I'm getting a compile bug. (Probably I'm doing something silly, or using the wrong version of Excel: Office XP Professional, by the way.) The offending line is... Dim oTbl As Table ... and the error is ... Compile Error: User-defined type not defined. The problem is that you posted in the Word newsgroup, so I wrote a macro that manipulates a Word table. (Yeah, maybe that is the wrong version of Excel. ;-) For an answer for Excel, post in the microsoft.public.excel.programming group. Good luck! -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#5
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Comparing cells, coloring differences
The problem is that you posted in the Word newsgroup, so I wrote a macro that
manipulates a Word table. (Yeah, maybe that is the wrong version of Excel. ;-) Oh my goodness! My apologies! |
#6
Posted to microsoft.public.word.formatting.longdocs
|
|||
|
|||
Comparing cells, coloring differences
In Excel you don't need a macro for this.
Use the Conditional Formatting, under Formatting menu. Hope this helps. DeanH " wrote: The problem is that you posted in the Word newsgroup, so I wrote a macro that manipulates a Word table. (Yeah, maybe that is the wrong version of Excel. ;-) Oh my goodness! My apologies! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic coloring of table cells | Tables | |||
Comparing subdocuments for differences | Microsoft Word Help | |||
coloring my Index | Microsoft Word Help | |||
Newbie: Coloring cells in a table. | New Users | |||
Text Box Coloring (Lemeva) | Microsoft Word Help |