The Excel Options dialog box displays. Calculates all open workbooks a specific worksheet in a workbook or a specified range of cells on a worksheet as shown in the following table. In the Number tab of the resulting menu click Percentage.
Just right-click on a cell that contains a decimal or a row or column full of such cells and select Format Cells.
If you want to color code commonalities between different rows in Excel you can do that. Calculates all open workbooks a specific worksheet in a workbook or a specified range of cells on a worksheet as shown in the following table. For simple formulas simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use the plus sign to add the minus sign - to subtract the asterisk to multiply and the forward slash to divide. And compare it to the Actual Expenses sheet the next one in the file.