You can eliminate the entry of more than 1 currency in a row with Data Validation, Custom and Enter a formula like this with F10 selected: =OR(G10="",H10="")
This will stop entry into F10 if either G10 or H10 has a value.
This would be laborious because it would have to be entered for each cell in the currency entry (modified of course to allow entry into the active cell)
Bookmarks