Excel tables allow different types of data to be displayed in different colors

Source: Internet
Author: User

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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.