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.


[TABLE="width: 1103"]
<colgroup><col span="2"><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]fig1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]fig2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DEC[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]JAN[/TD]
[TD][/TD]
[TD]Desc[/TD]
[/TR]
[TR]
[TD]ADVERT[/TD]
[TD][/TD]
[TD]ADVERT/MARKETING/PROMOTIONS/CATALOG[/TD]
[TD][/TD]
[TD][/TD]
[TD]ADVERT[/TD]
[TD][/TD]
[TD]ADVERT/MARKETING/PROMOTIONS/CATALOG[/TD]
[/TR]
[TR]
[TD]AUDIT[/TD]
[TD][/TD]
[TD]AUDIT & ACCOUNTANCY[/TD]
[TD][/TD]
[TD][/TD]
[TD]BANKCHG[/TD]
[TD][/TD]
[TD]BANK CHARGES[/TD]
[/TR]
[TR]
[TD]BADDEBT[/TD]
[TD][/TD]
[TD]BAD DEBT/WRITE OFF ADJUSTMENTS[/TD]
[TD][/TD]
[TD][/TD]
[TD]BUILDMAINT[/TD]
[TD][/TD]
[TD]Building Maintenance Charges[/TD]
[/TR]
[TR]
[TD]BANKCHG[/TD]
[TD][/TD]
[TD]BANK CHARGES[/TD]
[TD][/TD]
[TD][/TD]
[TD]dog[/TD]
[TD][/TD]
[TD]dog[/TD]
[/TR]
[TR]
[TD]BREAKDOWN[/TD]
[TD][/TD]
[TD]VEHICLE BREAKDOWN COVER[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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
[TABLE="width: 96"]
<tbody>[TR]
[TD]BUILDMAINT[/TD]
[/TR]
[TR]
[TD]dog[/TD]
[/TR]
</tbody>[/TABLE]