I am using Numbers where I created a table with two columns. The cells of the first column contain a drop-down menu with a list of currencies. What I am 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 another cell value.
Please let me know if it is possible in Numbers.
Thanks a lot.