How to make Excel display negative values ​​in red color

The reality is that initially it imposes a number of respect due, amongst different issues, to the interface that it presents to us, and the large quantity of capabilities it provides. But we should admit that when it comes to working with numerical information, it’s the most suitable choice we are able to use. In reality it’s a software program It has been round for variety of years and it continues to enhance and enhance its versatility. Hence, it’s utilized in all sorts of environments and is legitimate for many customers.

On the opposite hand, though at first it could appear complicated, which it’s, it additionally is determined by how a lot we wish to deepen its use. Keep in thoughts that right here we now have formulation and capabilities of all types, each fundamental and really complicated. To a big extent, all this can depend upon what we want or the diploma of complexity we’re on the lookout for. Therefore, for these of you who have no idea him properly, we’ll say that Excel is an software that works like a spreadsheet that’s used all around the world.

Some unknown Excel capabilities

But it is a software program resolution which not solely focuses on coping with numbers and formulation, however goes a lot additional. We inform you this as a result of in the mean time and thanks to the functionalities that it presents us, we even have the potential of utilizing different components. Here we refer to objects akin to tables, pictures, graphics, and so forth.

Excel objects

All of this shall be extraordinarily helpful to us when it comes to giving added worth to our work right here. In reality, we are able to say that this system as such has variety of capabilities that we most likely have no idea but and which are helpful.

This is exactly the case that we wish to discuss in these identical traces. And it’s that subsequent we’re going to discuss a quite simple operate, however that shall be very helpful in a lot of the sheets that you just make. To give us an concept of ​​what we’re speaking about, we’ll begin by saying that it is a program that by default reveals us negative numbers with a minus. This is finished, as you’ll be able to think about, in order that we are able to establish these values ​​at a look.

Mark negative values ​​in Excel in red

But it will also be the case that on the identical time this technique doesn’t fully persuade us. Therefore, to customise this display system, this system provides some totally different choices. With this, what we obtain is to give one other format to the negative numbers and to give you the chance to distinguish them higher. For all that has been mentioned, we’ll inform you that in these identical traces we’re going to present you the way to change the way in which of seeing negative numbers by default in Excel. For all this we’re going to present you how one can configure all this and thus give you the chance to configure a personalised format.

In reality, it have to be taken into consideration that the Program provides us totally different built-in choices for this. It will largely depend upon the area and the language settings of the working system itself. What we imply by that is that in most areas we are able to see these negative numbers in red, black, or in parentheses. In the identical method, it’s standard that they’re proven with or with out signal much less in each colours.

negatives in Excel

Therefore, under we’re going to evaluate how to add further choices and thus customise the format of negative numbers within the Microsoft program. With this, what we’re actually going to obtain is change to a unique format. Therefore, the very first thing we should do is click on with the fitting mouse button on a cell or vary of chosen cells that we’re going to cope with. Next we could have to click on on the Format cells possibility of the contextual menu of this system.

Cell format

Therefore, within the subsequent window that seems on the display, we go to the tab referred to as Number. After that, within the left panel the place we see a listing, we choose the class additionally referred to as Number. It shall be at that second when in the fitting panel we could have the likelihood to select one of many choices proven within the Negative numbers part. Therefore we now have to choose one of many appropriate proposals proven right here, and to save the adjustments click on on the button to Accept.

Negative formats

In this manner, within the occasion that for instance we go for the red color that we see among the many samples, from that second all these negative numbers shall be highlighted on this color after we are designing our spreadsheet.

Create a customized negative quantity format

Another level that we should keep in mind is that this system additionally offers us the chance to create our personal codecs. By this, what we imply is that we’re going to have larger management over how the info we work with is displayed. To do that, the very first thing we do is click on with the fitting button on a cell and choose once more Cell format. Then, we additionally go to the Number tab and go for the Custom class within the left panel.

Custom negatives

Therefore at that second we’ll discover a listing with totally different codecs in the fitting pane of the window. Say that every of them consists of a most of 4 sections separated by semicolons between them. The first is for optimistic values, the second for negatives, the third for zero values ​​and the final for texts.

These are samples that Excel presents to us to give us an concept, however we are able to create our personal format. For instance, if we wish to visualize a format of negative quantity, in red, between parentheses and with out decimals, the format to create could be the next: #, ## 0;[Rojo](#, ## 0). This is what we might have to enter within the Type field.