Excel makes the payroll, if you want to make more than equal to 2000 million of the total wages to "red" display, greater than or equal to 1500 yuan of the total wages to "blue" display, less than 1000 of the total wages to "brown" display, and other "black" display, we can set this.
1. Open the Payroll workbook, select the column for payroll, and perform the format-conditional Format 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.
2, press "Add" button, and imitate the above operation set other conditions (greater than or equal to 1500, the font is set to "blue"; less than 1000, the font is set to "Brown").
3, after the setup is complete, press the "OK" button.
Look at the payroll, and the payroll figures are displayed in different colours according to your requirements.