![]() Select the new format in the Format list. Setting the format after you already pasted the data doesn’t always change the format correctly. However, if it does not, try another color.ĩ. Select the range of cells and then either right click and select Format Cells or from the top of page menu select Format, Cells. If the new format appears in the Format list, you are good to go. Click the add icon (the button with the check mark).Ĩ. Change the word RED to a different color, such as BLUE or GREEN.ħ. In the Format code text box, you will notice some code (for example #,#0.00 -#,#0.00 or 0 -0).Ħ. Red may not be your color of choice, if that’s the case, you can use a different color by following these steps:ĥ. In the Options section, check the Negative numbers red checkbox.Īll negative numbers within the range will now be displayed in red. This makes it much easier to find problem areas. When analyzing your spreadsheet, especially if it contains financial data, it can be quite helpful to have negative numbers standout as a different color from the positive ones. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |