How to Automate Number Formatting

[Purwadi]

Hi, I am new in this community.  I need help on how to automate number formatting in Excel.

Attached please find the file in which I have a simple table containing 3 metrics, i.e.  

- EBITDA, with a value in round number format

- Current Ratio, with a value in decimal number format

- ROE, with a value in percentage format

On the right to the table, I made a data validation list for the metrics, with which I can select one of them.  Below it, I use XLOOKUP to display the value for the metric I select.  I would like to have the number format update itself automatically each time I select a metric.  I can do it using VBA codes.

Is it possible for me to do it using functions and formulas instead of VBA codes?

Regards,

Purwadi 

[#2 · Accepted solution]

@Purwadi 

You may apply 3 conditional formatting rules, one for each type of formatting, as

[#3]

Hi @Sergei Baklan,

Thank you so much for your prompt response.  

I really appreciate it.

Purwadi

[#4]

@Purwadi , you are welcome