How to highlight Negative numbers in Excel

When working with numbers in Microsoft Excel, you’ll be able to highlight destructive numbers in purple; this makes it simpler to learn information. There are a couple of strategies that you need to use to highlight destructive numbers, corresponding to utilizing conditional formatting, inbuilt quantity formatting, and utilizing customized formatting. The Conditional Formatting function simply spots traits and patterns in your information utilization bars, colours, and icons to visually highlight essential values. It’s utilized to cells primarily based on the values it holds.

How to highlight Negative numbers in Excel

You may highlight cells with destructive values in Excel and make them stand out in Pink utilizing considered one of these strategies:

1. Utilizing Conditional Formatting
2. Utilizing Customized Formatting

1] Utilizing Conditional Formatting

In Excel, you’ll be able to format a destructive quantity by making a Conditional Formatting rule.

1. Choose the vary of cells containing the numbers.
2. On the Dwelling tab, in the Types group, click on the Conditional Formatting button.
3. Hover your cursor over Highlight cell guidelines after which click on Much less Then.
4. A Much less Than dialog field will open, click on the drop-down arrow, and choose a highlight, for example, Gentle purple fill with darkish purple textual content.
5. Click on OK.

All of the cells of destructive numbers will grow to be purple, whereas the constructive numbers will stay the identical.

2] Utilizing customized formatting

You may create your individual customized format in Excel to highlight destructive numbers.

Choose the vary of cells containing the numbers.

On the Dwelling tab in the Numbers group, click on the small arrow button or press the shortcut keys Ctrl + 1.

A Format Cells dialog field will open.

On the Quantity tab, choose Customized on the left pane.

On the fitting in the Sort part, kind into the entry field the format code Normal;[Red]-Normal.

Then click on OK.

All of the destructive numbers will grow to be purple, whereas the constructive numbers will stay the identical.

We hope this tutorial helps you perceive how to highlight destructive numbers in Excel; you probably have questions concerning the tutorial, tell us in the feedback.

How do I make destructive numbers purple in Excel?

You may highlight cells with destructive values in Excel and make them stand out in Pink utilizing considered one of these strategies:

1. Utilizing Conditional Formatting
2. Utilizing Customized Formatting

How do I apply conditional shade in Excel?

If you need to add situation shade in Excel, comply with the steps beneath:

1. Click on Conditional Formatting button in the Types group.
2. Click on New Rule in the menu.
3. Choose a method, for instance, 3-Coloration Scale, choose the situations that you really want, after which click on OK.

What’s highlight cell guidelines in Excel?

Whenever you click on the Conditional Formatting button in Excel, you will notice the Highlight Cell Guidelines function. The Highlight Cell Rule function is a sort of conditional formatting used to change the looks of cells in a variety primarily based in your specified situations.

What are the 4 sorts of conditional formatting?

There are 5 sorts of conditional formatting visualization out there; these are Background Shading of cells, Foreground shading of cells, Information bars, and Icons, which have 4 picture sorts and values.

READ: Change Cell Background Coloration in Excel with VBA Editor

How do I mechanically highlight cells in Excel primarily based on worth?

Observe the steps beneath to mechanically highlight cells in Excel primarily based on worth.

1. On the Dwelling tab in the Types group, click on the Conditional Formatting button.
2. Click on Handle Guidelines.
3. Create a brand new rule.
4. Within the Choose a rule show field, choose use formulation to decide which cells to format.
5. Enter a worth for example =A2=3.
6. Click on the Format button.
7. Click on the Fill tab after which select a shade.
8. Click on Okay for each containers.
9. The colour of the cell will change.

READ: How to navigate between Excel worksheets utilizing Command button.