Apr 18 2020 08:44 PM
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
Apr 19 2020 03:50 AM
SolutionApr 21 2020 05:27 AM
Apr 19 2020 03:50 AM
SolutionYou may apply 3 conditional formatting rules, one for each type of formatting, as