SOLVED

How to Automate Number Formatting

Highlighted
New Contributor

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 

3 Replies
Highlighted
Best Response confirmed by Purwadi (New Contributor)
Solution

@Purwadi 

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

image.png

Highlighted

Hi @Sergei Baklan,

Thank you so much for your prompt response.  

I really appreciate it.

Purwadi

 

 

Highlighted

@Purwadi , you are welcome