Reconciliation

  • Thread starter Thread starter osaka78
  • Start date Start date
O

osaka78

I have a file with more than 2000 rows i want to reconcile as follows
A B
1 100
1 (100)
2 200
2 250
3 50
3 (50)
3 100

If 1 is 100 and 1 is (100) then highlight , So the result is Highlighted 1
and two lines of 3
 
Use conditional formatting.

Highlight entire range (A1:B100 for example) and apply conditional
formatting formula. Under "Formula Is:" type the following:
=AND($A2=$A1,SUM($B2,$B1)=0)
choose your number formatting and apply the formatting.
 
Back
Top