I have a sheet where users enter a value of an invoice in one of three
columns. These are Pounds sterling, US dollar and Euro. The invoice
will only ever be in one of the three currencies.

Can I flag a warning if values appear in more than one of the three
cells on each row?