You can always ask an expert in the Excel Tech Community or get support in the Answers community. When you type a negative percentage within the selected range, it will automatically be formatted in red. In the Format Cells box, select a font or cell color, and then click OK twice. In the Edit the Rule Description popup, in Format only cells with, select less than. Negative values are surrounded by parentheses. In the New Formatting Rule box, select Format only cells that contain. Displays numbers with currency symbols and decimal points in a column. On the Home tab, click Conditional Formatting > New Rule. In a worksheet, select the range of cells in which you’ll be entering negative percentages. To use a custom format in other workbooks, save the workbook as a template, and then base future workbooks on that template.įollow these steps to create a custom formatting rule-which will only be available in the worksheet in which you create it. The next time you need to apply it, follow steps 2 and 3 above, and you’ll find the custom format in the Type list. Tip: Custom formats are saved with the workbook. I have been able to format single cells to display negative percents (Budget to Actual hours), but I cannot copy the formatting to cells with positive.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |