Highlight differences

[rovert]

Hi All,

Thank you in advance, what i need is to be able to highlight the difference between 2 worksheets in the same workbook, fig1 below is sheet1 and fig2 is sheet2.

fig1					fig2
DEC					JAN		Desc
ADVERT		ADVERT/MARKETING/PROMOTIONS/CATALOG			ADVERT		ADVERT/MARKETING/PROMOTIONS/CATALOG
AUDIT		AUDIT & ACCOUNTANCY			BANKCHG		BANK CHARGES
BADDEBT		BAD DEBT/WRITE OFF ADJUSTMENTS			BUILDMAINT		Building Maintenance Charges
BANKCHG		BANK CHARGES			dog		dog
BREAKDOWN		VEHICLE BREAKDOWN COVER

<colgroup><col span="2"><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>

thanks again.

 

[SteveO59L]

and what do you want to highlight?

new entries?

 

[rovert]

Hi SteveO59L,

I need to be able to highlight any differences in the Jan sheet, so "Buildmaint" and "Dog" would highlight as they are not in the Dec sheet.

Thanks

 

[jim may]

Select Sheet2 and Click the Column Header "A" (the entire column A will be highlite)
With Column A still selected - Go to Conditional Formatting and create a "NEW RULE"
Select from Dialog box the option - "Use a formula to determine which cell to format"
In the formula Textbox enter:

=AND($A1<>"",NOT(COUNTIF(Sheet1!$A:$A,$A1)>0))

Double check the "Applies to: textbox to verify the it reads: =$A:$A
Click the Format... Button and Select a Fill Color --then OK, OK, out of Dialog box

Only these two (below) should be highlighted with your selected Color

BUILDMAINT

dog

<tbody>
</tbody>