Hi all,
I am looking for some assistance on the best way to control Currency of selected cells based on another cell value. I have attached a worksheet as an example.
I am looking to have the currency in cells D3:D26, E3 and H3 update when I select the currency in cell H6. I have added $ and £ but I will have a more comprehensive list in the final sheet.
I have tried some conditional formatting with formulas but have failed miserably.
As always all assistance, suggestions and help is very much appreciated.
Kind regards
Leigh
Bookmarks