Intercompany balances

I need to create a matrix to check the intercompany balances for a group of 40-50 companies. I'm currently using Excel 2010 and have been told that pivot tables or conditional formatting may be of use.

Sadly I'm no expert on Excel (especially 2010), so any detailed help would be greatly appreacated.

Thanks in advance!

Comments
There is 1 comment. Login or register to view it.

This has been answered before

BillC |