How to set conditional formatting in Excel: First open the document, select the data that needs to be conditionally formatted; then click "Conditional Formatting" above, click "Highlight Cell Rules", and then select "Greater Than" on the right option; then set the conditions; and finally click OK.
The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.
How to set conditional formatting in excel:
1. Open an Excel document that requires conditional formatting.
#2. Select the data that needs to be conditionally formatted.
3. Then click "Conditional Formatting" above, click "Highlight Cell Rules" in the first list, and then select the "Greater Than" option on the right.
#4. In the pop-up dialog box, set the conditions. Here, enter the number "3" in the first text box (indicating that you want to set conditional formatting on data greater than 3). Click the small triangle to the right of "Set as" and select the format that needs to be set to meet the conditions.
#5. Click "OK" after setting.
#6. In this way, all data greater than "3" are filled with light red, and the numbers also become the set dark red.
Related learning recommendations: excel tutorial
The above is the detailed content of How to set conditional formatting in excel. For more information, please follow other related articles on the PHP Chinese website!