If you want to show negative numbers in red color in Google Sheets, then you can do this using conditional formatting and custom formatting.

Sometimes using color-changing cells in a spreadsheet can be a handy visual aid for quickly assessing data. If you’d like this feature on Google Sheets, it’s very easy to set it up so that a cell ...

The error "Too many different cell formats" in Excel occurs when the data in Excel exceeds the formatting limit. Here are some solutions to try.

Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might want the row color to change based upon a credit or debit on a ...

We show various ways to cross out a number or text on spreadsheets by adding strikethrough formatting in Microsoft Excel.

The number in the cell has a leading zero because the format tells it to do so. (explained in earlier tip – formatting numbers.) Here I wish to display this number with a space between the fourth and ...

However, if you paste a differently formatted date, Excel accepts the source formatting. To further complicate the situation, Excel changes the format of the target cell to that of the pasted value!

Having produced a summary calendar within excel, with each cell representing a different day. Where tow distinct activities happen on the same day is it possible to format the cell into two halves and ...

First, typing currencies manually could lead to number format inconsistencies, where some cells are formatted as a financial value, and others are not.