Office how to move the calculation results shows negative numbers in red, for example: 1, 5, 4

In column F, the number of personnel in column A cannot exceed the corresponding number of times, and the excess is shown in red, and the specific steps are as follows:

Select column A:C and click Menu Bar - Start - Conditional Formatting - New Rule.

If you select Use Formula to determine the cells to be formatted as Rule Type, enter the formula: =countif($a:$a,$a 1)>vlookup($a 1,$e:$f,2,0).

Click the Format button.

The Format Cells interface pops up, and click the Fill tab.

Select a color and OK.

In this case, the format rules page will be returned, OK.

Those who did not comply with the rules were marked in red.

Description of the formula. countif (find in **, what to find): the number of conditional statistics;

vlookup(what to find, find in **, return the first columns, 0): match data;

The countif function counts the number of names in column A, and the vlookup function matches the maximum number of occurrences of each name in the specified list. If the number of entries counted by the countif function is greater than the maximum number of times, the number of occurrences in column A exceeds the number specified in the list.

Right-click cell settings, there are in the format, for example, select "number" There are several display formats to select, if it is not satisfied, you can achieve it by customizing the format.

Computer-savvy people generally do.

Are you talking about the situation in Excel**?

Select the column where the calculation results are stored, format the cells, --- the number --- currency the negative number, and select the row with the "-" sign in black.

Select the cell where you want to put the result.

Right-click=>> cell format=>> number=>> numerical =>> has the form of selecting a negative number.

See screenshots such as column ab.

Select column A:B to get started>> Conditional Formatting > New Rule > Use Formula to Determine Cells to Format >> Format values that match this formula, fill in the formula =A1<0

Format > Font > Color > Select red, OK.

Select the cell area you need to set, click the "Conditional Formatting" button at the top--- create conditional formatting--- only format the cells containing the following contents--- fill in the cell value less than 0 in the rule -- and then click Format to set the background color, font color, whether to be bold, etc.

1. Select the range of cells you want to set.

2. Right-click and select Format Cells to open the Format Cells dialog box.

3. Click the data label, select Custom, and enter 0 in the type. [Red]-0; 0;@ Click OK.

4. **Format introduction: Custom cell format** with three semicolons in English state (; Divided into four paragraphs, each paragraph represents a positive number, a negative number, a 0 value, and a text, and in the ** used above, 0 is a number placeholder, @是文本占位符.

You want to achieve what you said, here's how to do it:

For example, column A is the order quantity, B column is the actual quantity, and C column is the underquantity, and no value is entered first.

In the missing column (C2) input function =B2-A2 (enter into a long blank space in the toolbar on the top of Excel, pay attention to enter in the state of English input method).

Then Ctrl+C selects A2, B2, C2

Copy to A3, B3, C3 and all the following columns (e.g. my annual statistics table is usually copied to line 100).

Then select all C columns vertically.

Then click Format -- Conditional Formatting.

Select the cell value to be less than 0

Formatting (enter the dialog box, "Color" adjust the font color to red) OK?

Hello Many times, in order to view the data more intuitively, we will use different colors in excel to distinguish positive and negative numbers. In column d as shown below, positive numbers are indicated in green and negative numbers are indicated in red.

Method 1: Use a custom format to distinguish between positive and negative colors.

Select the data in column D, press CTRL+1 to open the custom format, and enter **:[Green]; [Red]; -

** Meaning: How positive numbers that are greater than 0 are shown as a percentage of green 2 digits, and negative numbers less than 0 are shown as a percentage of 2 digits in red.

Method 2: Use conditional formatting to distinguish between positive and negative colors.

Select the data region, Conditional Formatting - Highlight Cell Rules - Greater than, Less than to set the color.

Let's set the color with a negative number less than 0, so that after setting, the data change trend is not very conspicuous. Of course, there are other methods, but these two are relatively simple.

d5.

max(0,(d3-d4)/d3*100)

This means that the maximum value is taken between the calculation result and 0.

Did all the numbers in your column D be typed in directly, pasted in, or calculated using a formula?

I think there should be more than one negative number in your **d5, only one of which you can change directly, if it is a formula to calculate the best thing to do.

So to ask.

Customize the data type as.

0]"0";g Common format.

You want to achieve what you said, here's how to do it:

For example, column A is the order quantity, B column is the actual quantity, and C column is the underquantity, and no value is entered first.

In the missing column (C2) input function =B2-A2 (enter into a long blank space in the toolbar on the top of Excel, pay attention to enter in the state of English input method).

Then Ctrl+C selects A2, B2, C2

Copy to A3, B3, C3 and all the following columns (e.g. my annual statistics table is usually copied to line 100).

Then select all C columns vertically.

Then click Format -- Conditional Formatting.

Select the cell value to be less than 0

Formatting (enter the dialog box, "Color" adjust the font color to red) OK?

Set the cell: select the numeric value in the number tab, and select the corresponding item for the negative number.

Select the cell you want to set, then Format-Conditional Formatting-Then change the interval to less than, fill in 0 after it, and then select the following format as the color you want to become.

Select all the data, and then click Conditional Formatting under Format, and set it right.

Right-click - Format Cells - Numbers, there are optional formats inside.

In Excel, negative numbers can be displayed as numbers contained in red parentheses by formatting cells.

Operating system: win10; Software version: Office 2007 is illustrated as follows:

1.Display the negative numbers in column A as numbers in red parentheses:

2.Select column A, right-click, Format Cells:

3.Select the numeric value, and the negative number is selected as follows:

4.OK, done:

Select the cell by right-clicking"Format cells"

Select under the number tab"Numeric value"Then select the red one (1234) on the right side and click Confirm.

In B1, do the following:

1: Formatting – Conditional formatting.

You can use conditional formatting to fill the 0 and negative numbers in the K column of Excel in green, and the positive numbers in red.

Software version: office2007

Here's how:1Fill the 0 and negative numbers in the K column in green, and the positive numbers in red

2.Select the data area, click "Conditional Formatting" in the beginning, highlight, greater than:

3.Set the value to 0 and the format is red text, click OK:

4.In the same way, set less than 0 and equal to 0 respectively, and format it as green text:

5.Once the setup is complete, the result looks like this:

The first step, of course, is to select the area you want.

Then click "Conditional Formatting", "Highlight Cell Rules", "Other Rules", and then click "Conditional Formatting".

After that, follow the instructions in the image below to select the appropriate rule.

Pay attention to the selection of cell formatting.

After that, it's time to choose the format of the fill.

Then click the OK button in the initial dialog box.

At this time, the part greater than or equal to zero has been done, and the part less than zero can be done in the same way.

Select column k, set "conditional formatting", and use this suggestion to write your data as follows, write on the top of the half, (unit: 10,000), and remove the 10,000 characters of the data below.

0 and negative numbers are filled with green.

Select all K columns. From the menu, select Start Conditional Formatting New Rule

Choose "Use formula to determine which cells to set" in the pop-up list, enter the following in "Format values that match this formula", then set the green background in "Format", and then click OK

and($k1<>"",$k1<=0)

Positive numbers are filled with red.

Select all K columns. From the menu, select Start Conditional Formatting New Rule

Choose "Use formula to determine which cells to set" in the pop-up list, enter the following in "Format values that match this formula", then set the green background in "Format", and then click OK

and($k1<>"",$k1>0)

Check Column K Start Conditional Formatting New Rule Use formula to determine which cells you want to setEnter formula: =k1<=0 Set formatting: (green) OK Create a new rule again and set another color.

Enter formula: =k1>0 Set format: (red) OK.

If the cell is a numeric value, check the data column, Format Cell, Custom format, Enter.

[Red]-0; [Green]-0; [Green]-0;

In excel cells, there are many ways to represent negative numbers:

1.red, positive numbers in parentheses;

2.blue, positive numbers in parentheses;

3.Red, positive;

4.blue, negative;

5.Red, minus!

These are all negative numbers.

Select the range of cells where you want to display negative values--- format the cells --- --- negative numbers.

Format Cells--Digits--Digits--Negative Numbers--Select the number format with negative signs.

Enter -1 in an empty column, such as -1 after copying the whole column, and then enter the formula in the empty column, that is, multiply the first two cells, copy the formula, and then select the column with the formula, copy, and select in the empty column"Paste special"-"value", and then delete the previous useless ones.

Set the cell format and numeric value, and then look at the negative number display box on the right.

The format of the cell number is determined.