Good day,
Please see enclosed my Net Present Value calculation. I have made a drop down menu for the different currencies so that the formatting automatically changes into what I would like to be, using the Conditional Formatting function.
It looks really nice on the calculation sheet, but the currency formatting is not carried over to the Graph Axis'. It seems to carry over the cell formatting. I can only guess this is a limitation in excel.
However is there another way, maybe via formula's to change the cell formatting to what it is right now? I think the drop down menu I can solve with the IF function as well, but have no idea about a formatting function.
Thanks!!
Ian
Bookmarks