In a multi-currency environment my staff keep mixing up currencies in
their spreadsheets e.g. subtracting costs in dollars from revenues in Euros.

I would like to develop a macro that examines formulas in a spreadsheet
and looks for cells formatted in different currencies.

Some pointers on how to get started would be appreciated.