How to fill gradient in excel

How to fill gradient in excel?

Taking office excel 2016 as an example, the steps are as follows:

The tools we need are: computer, office excel 2016

1. First open the excel table and select The data content that needs to be filled with gradient color, then click the "Start" menu in the upper menu bar.

#2. Then find the "Conditional Formatting" option in the menu and click "New Rule". You can also directly use the template option above.

#3. In the dialog box for creating a new format rule, set the rule type, cell style, color, etc. according to your needs, and confirm.

#4. After confirmation, the selected data content will be filled with color according to the set conditions.

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of How to fill gradient in excel. For more information, please follow other related articles on the PHP Chinese website!