TradingJournal Dashboard - Dynamic Decimal Points/Spaces

[ecronic]

Hi all,

As per the topic, what I'm trying to achieve is to select a particular currency from dropdown list (column E) and the columns L, M, N, O & X shoud be formated to have specific decimal places as per the currency selected. So far, I was only able to achieve this by conditional formatting but the list of currency is long so having so many conditions doesn't seem like doable approach.

Workbook with sample data is included and this is a macro enabled workbook as I have VBA formulas so profit/loss calculations. More information is included in the workbook.