How to set different colors for different data in Excel

Excel spreadsheet is a data processing software with very powerful functions that can meet various office needs. If you need to display different data in different colors in the Excel spreadsheet, how should you do it? In fact, the operation method is very simple. I will share the method with you below. Method 1: Select the data and press Ctrl+1, or right-click and click Format Cells, or click the small icon in the lower right corner of the number column in the Home tab.

2. Click Customize in the number field, enter the format as shown below and confirm.

Method 2 1. After selecting the data, click Conditional Formatting on the Home tab - Highlight Cell Rules - Select the Greater Than Less Than Between condition in order to set it.

Method 3

1. After selecting the data, click Manage Rules under Conditional Formatting - New Rule - Only format cells containing the following content - Set the font and format and confirm, then create a new rule again. Settings, for example, we have created three new rules here, set different formats respectively, and then confirm.

   

The above is the detailed content of How to set different colors for different data in Excel. For more information, please follow other related articles on the PHP Chinese website!