Learn how to show formulas in cells instead of values or calculated results In Microsoft Excel. You can show or hide formulas in Excel cells.

Now, we will use this GCD value to calculate and display the ratio in our targeted cells. Use the following formula to calculate and display the ratio in Excel.

In a future article, I’ll show you how to use Excel’s conditional formatting feature to highlight the top three ranking values.

Thanks to the linked cell property in Microsoft Excel, it's super easy to use the selected value as a condition in a macro or conditional formatting rule.