Hi,
Can anyone please advise me of the formula I need to use in conjunction with ‘Conditional Formatting’ to look in column ‘A’ for the currency i.e. £ (GBP), $ (USD) or € (EUR) and format the currency values in the corresponding cells in columns ‘B’, ‘C’, ‘D’, ‘E’. i.e. insert £, $ or € signs (please see attached Example.xlsx workbook)
e.g.
if A2 = £ (GBP) then format the values in B2, C2, D2 and E2 with a lead £ sign
if A5 = $ (USD) then format the values in B5, C5, D5 and E5 with a lead $ sign
if A8 = '€ (EUR) then format the values in B8, B8, D8 and E8 with a lead € sign
Many thanks in advance for any assistance received
Regards
Rob
Bookmarks