How Excel can set different data to display different colors

In the salary table, if you want the total salary greater than 2000 yuan to be displayed in "red", greater than 1500 yuan, less than 2000 yuan in total salary in "yellow", less than 1000 yuan in "green", and others in "black", as shown in the figure below, we can set it like this.

How to display different types of data in different colors in Excel.

Tools Raw materials.

excel 2007

Method Step 1

Select the number cells that need to be processed, and click "Start-Conditional Formatting-Highlight Cell Rules-Greater than", as shown in the following figure:

How to display different types of data in different colors in Excel.

In the pop-up dialog box (shown in Figure 1 below), enter 2000 on the left and select "Light Red Fill Dark Red Text" on the right. Click OK to see the filling effect as shown in Figure 2 below.

How to display different types of data in different colors in Excel.

How to display different types of data in different colors in Excel.

Repeat the first step, select "Between" in the "Cell Rules" submenu, fill in the dialog box that pops up, fill in between 1500 to, click on the right to select "Yellow Fill Color Dark Yellow Text", and click OK. This is shown in the figure below.

How to display different types of data in different colors in Excel.

How to display different types of data in different colors in Excel.

Repeat the first step, select "Less than" in the "Cell Rules" submenu, fill in 1000 on the left in the pop-up dialog box, click on the left to select "Green Fill Color Dark Green Text", and click OK.

How to display different types of data in different colors in Excel.

The final result is shown in the following figure:

How to display different types of data in different colors in Excel.

Careful people will find that 2000 yuan is still displayed in black on a white background, there is no greater than or equal to in excel, if you want to make the data greater than or equal to 2000 yuan are displayed in red, then repeat the first step again, select equal to after "cell rules", enter 2000 in the pop-up dialog box, and click on the right to select "light red fill color dark red text". Click OK.

For example, in a table, if you want data to be greater than or equal to a certain number (e.g., 10) to be displayed in red, data to be greater than or equal to 20 to be displayed in blue, data to be greater than or equal to 30 to be displayed in brown, and data less than 10 to be displayed in gray.

Open the excel workbook, select the column where the data is located, and run the "Conditional Formatting Highlight Cell Formatting Rules (h) Other Rules" command.

In the New Format Rule dialog box, set the cell value to Greater than or equal to the condition and enter 10 in the data box.

Click the "Format" button to enter the interface of formatting cells, click the "Font" option, then click the "Color" drop-down dialog box, select the color as "Red", and click "OK" to complete the setting.

Set the other conditions as described above (greater than or equal to 20, the font is set to "blue"; Greater than or equal to 20, the font is set to "brown"; Less than 10, the font is set to "gray").

Once the setup is complete, press the "OK" button.

Take a look at this table, whether the data is displayed in different colors according to your requirements. In this way, different colors can be filled in different data**, and users can set them according to different needs.

Take Excel2011 as an example:

<>3, and then select the same set of data.

4. Click on the logo of the magnifying glass above, and select "Targeting" from the arrow down.

<>6. Click on the fill color and select the desired color.

7. Finally, you can see that the same set of data has the same color, so that the operation can solve the problem.

Excel**Different percentage data is displayed in different colors, and the specific steps are as follows:

1. In the first step, enter the number that needs to be set to fill the color in Excel to be displayed as a percentage, and then select the cell as shown in the figure below.

2. In the second step, click on the "Conditional Formatting" option in the toolbar at the top of the page, as shown in the image below.

3. Step 3: Next, select the "New Rule" option in the drop-down menu that opens, as shown in the following figure.

Fourth, the next step is to pop up the set rule dialog box, then select the format style as "Data Bar", and then select the type as "Percentage", as shown in the following figure.

5. Step 5, next set the bar chart direction to "From Left to Right", then select the appropriate color and click the OK button, as shown in the figure below.

6. In the sixth step, the selected cells can be displayed according to the input number to display the color of the filling, as shown in the following figure.

When formatting the data bar, divide it into different types of colors according to the required proportion, assuming that you need to display red, yellow, and green colors at 30%, 60%, and 60% or more. You need to set more than 60% of the conditions first, set the maximum value to 1 according to the number, and set the minimum value to the formula, the formula is =if (target cell 60%, 0,""Set the color to green, and set the fill effect to solid or gradient as you like. So the first condition is set.

Then according to the second option, the maximum value is still the number 1, and the minimum value formula is =if(target cell<=60%,0,""Set the color to yellow; The third way is to set the formula to =if(target cell<=30%,0,""Set the color to red. Note: The sorting of conditional formatting must be red, yellow, and green. That's it.

If you still have questions, you can contact me on Know.

1. Open the excel** program and enter the main interface of the program.

2. Next, click on the highlighted option above the excel program and click on open.

3. Next, click on the "Duplicate Value" option to open.

4. Next, set "Other Format" in the window and click to open.

5. Select one of the display colors in the window.

6. Finally, you can see that the same cell in excel shows the same color setting is completed, and the problem is solved.

1. First of all, we construct some data in Excel.

2. Then the function we want to implement is to display the results of different segments in different colors, first we click on conditional formatting, and then click on new rule.

3. Then we select only to format the cells containing the following in the new format rule, and then we first select the cells that are greater than or equal to 90 points, here select the cell value, then select greater than or equal to, then enter 90, and then click Format.

<>4. Then we select the fill label, select green, and click OK.

5. Back to Excel, you can see that all the cells with more than 90 points have been filled in green.

6. Next, we select the cells with 60-90 points, follow the previous steps, select between in the new format rule dialog box, and then enter 60 and 90, and then select the format.

7. Here we choose to fill in yellow, and then confirm.

8. Back to the cells, you can see that the cells with 60-90 points are also filled with colors, which is the effect of displaying different data with different colors.

1. First of all, enter the data of different colors that you want to mark in Excel**.

2. Select cell A1, and then click the "Filter" button in the "Data" option.

3. Then select a set of the same set of data to display in the cells.

4. Then click the "Positioning" option in the toolbar.

5. Select "Visible Cells" in the "Open Positioning" dialog box, and then click "OK".

6. Then click the Fill Color button and select the desired color.

7. Then repeat the above operation, each set of the same data can be marked with a different color.

1. First open the excel2013 document and <>

2. Then select the content, click the "Start" function, and <>

3. Then select the "Conditional Formatting" function and <>

4. Then select the "Levels" function, as shown in the figure below, <>5. Select the format of the first row and the first column, and <>

6. After setting, as shown in the figure below, complete the rendering.

1. Open the excel sheet and find the conditional formatting in the style options box.

2. Select the highlight cell rule.

3. Select the "Between" option.

4. Enter the range of values to be set.

5. Select a color and save it.

Run Microsoft Office Excel 2003 on your computer, as shown below.

Create a payroll form in an excel sheet as shown below.

In this example, if we want to meet the requirements like this: in the salary table, if we want the total salary greater than or equal to 2000 yuan to be displayed in "red", the total salary greater than or equal to 1500 yuan to be displayed in "blue", the total salary less than 1000 yuan to be displayed in "brown", and the others to be displayed in "black", then we can do it like this: first, select the "total salary" column, as shown in the figure below.

Then find "Formatting – Conditional Formatting" on the menu bar as shown below.

After clicking "Conditional Formatting", a conditional formatting dialog box will pop up on the worksheet as shown in the following figure.

At this time, don't worry about the rest, just click on the drop-down button on the right side of "between", as shown in the figure below, select "greater than or equal to" on the drop-down list, and enter "2000" in the number input box on the right.

<> click "Formatting" to the right of the conditional formatting box. At this time, the following cell formatting box pops up on the window.

Find the "Color" tab in the middle of the cell formatting dialog box, click the add button on the right side of the blank box below it, and the following color selection box will appear.

At this time, we follow the established requirements, and we need to choose red. After we click on the red color and press the "OK" key, the shape of the conditional formatting box is shown in the image below.

At this point, we also need to set the other data colors, so we click the "Add" button at the bottom of the dialog box, and a new interval and data input and formatting boxes appear. Use the same method as above to set the settings, and set the other conditions (greater than or equal to 1500, the font is set to "blue"; Less than 1000, the font is set to "brown"). After that, we get the results as shown in the figure below.

<> finally confirm that the settings are correct, click "OK" at the bottom of the settings box, and it is OK. The effect is shown in the figure below.

Precautions. A variety of conditions require the use of the Add button.

You should be careful in the selection of interval conditions, otherwise you will not be able to achieve your own requirements.