Design colorful numbers in Excel2000

zhaozj2021-02-11  256

Design colorful numbers in Excel2000

Keywords: Excel2000

When you use the Excel2000 to process the data in a work table, sometimes some of the data can have their own special display formats? For example, now you have an Excel worksheet as the picture, in the "total grade" column, you need to be less than 120 as blue, greater than 120 display is red. The following method can make your wish become a reality. This method is: 1. Select the cell area of ​​D2? D5. 2. Click the "Cell" command in the Format menu and click the Number tab. 3. Click the "Custom" option in the "Category" list, type "[Blue] [<120] in the" Type "box; [red] [> = 120]". 4. Click the "OK" button. How, Excel shows the number of different colors according to your requirements? Finally, the digital format code typed in the "Type" box is simply explained, "[Blue]" is the setting of the display color of the data, except "red", "blue", six colors can also be used They are black, cyan, green, magenta, white, yellow. "[> = 120]" is the conditional setting, and the conditional operators available:>, <,> =, <=, =, <>. When there are multiple conditional settings, each condition is set to a semicolon ";" interval.

转载请注明原文地址:https://www.9cbs.com/read-4871.html

New Post(0)