I use Numbers where I created a table with two columns. The cells in the first column contain a drop-down menu with a list of currencies. What I’m looking for is a way to set the currency format of the cells in the second column based on the values of the cells in the first column. To be more explicit, it would be a conditional formatting to set up currencies based on a different cell value.
Let me know if it’s possible in Numbers.
Thanks so much.