How do I get Excel 2007 to display sorted sorting filtered data in different colors

Excel has the ability to sort and filter data in its own right. How do I make Excel2007 use different colors to display sorted sorting filtered data? So that after the operation to have a more intuitive display, we need to let the data have a different color display, so that our work more efficient and more accurate, Below we will explain how to make Excel2007 use different color display sorting sorted filtered data

In the payroll, if you want to be greater than or equal to 2000 of the total wages to "red" display, greater than or equal to 1500 yuan in the total wages to "blue" display, less than 1000 of the total wages to "brown" display, and other "black" display, we can set this.

Step 1. Open the Payroll workbook, select the column for payroll, and execute the start → style → conditional formatting command to open the Conditional Formatting dialog box. Click the Drop-down button to the right of the second box, select the greater than or equal to option, and enter the value "2000" in the box that follows. Click the Format button to open the Format Cells dialog box and set the font color to red. The following figure

Step 2, press the "Add" button, and follow the above action to set other conditions (greater than or equal to 1500, the font is set to "blue"; less than 1000, and the font is set to "Brown").

Step 3, when the settings are complete, press the OK button.

Look at the payroll, and the payroll figures are displayed in different colours according to your requirements.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join