In columns F and H of a spreadsheet I have various currencies (e.g. USD, EUR, CHF). Column F always contains a currency, but column H does not have to and so is sometimes blank.
I need a formula that will highlight cells which have the same currency in a given row. Thus if there is only a currency in column F this is fine, or if there are different currencies in F and H also fine, but if F and H have the same value, both cells are highlighted.
Any ideas? I imagine conditional formatting is the way to go but no idea how to write the formula. Is it necessary to have the currencies as a named range to refer back to (and thus enter into the formula), is there just a way of seeing if the values in the cell are the same?
Also, for rows that do contain 2 currencies (F + H filled in), the value in that row's D must be "Cross Currency - Swap" - is there any way of incorporating that into the same formula or bit of code?
Would appreciate any help!
I need a formula that will highlight cells which have the same currency in a given row. Thus if there is only a currency in column F this is fine, or if there are different currencies in F and H also fine, but if F and H have the same value, both cells are highlighted.
Any ideas? I imagine conditional formatting is the way to go but no idea how to write the formula. Is it necessary to have the currencies as a named range to refer back to (and thus enter into the formula), is there just a way of seeing if the values in the cell are the same?
Also, for rows that do contain 2 currencies (F + H filled in), the value in that row's D must be "Cross Currency - Swap" - is there any way of incorporating that into the same formula or bit of code?
Would appreciate any help!
