How to Use WPS Conditional Formatting on Windows

Use Conditional Formatting through 5 how-to topics, including viewing the entry and categories, creating rules, and applying preset rules; choose a topic from the index and follow the entry path and steps.

How-to Index

How-to Guide

1. View the feature entry and preset categories

Entry path: Data tab → Conditional Formatting

1. Select the cell range where you want to apply conditional formatting.
2. Click Conditional Formatting on the Data tab.
3. Review the preset categories in the drop-down menu.
4. Choose from options such as Highlight Cells, Top/Bottom/Average, Data Bars, Color Scales, Icon Sets, New Rule, Manage Rules, or Clear Rules.

Success Criteria

• Interface result: The Conditional Formatting menu and its categories are visible.
• Next action available: You can continue to create, manage, or clear rules.

Tips While Using

• Common mistake: If you do not select the target range first, the rule may apply to an unexpected area.

2. Create a new rule

Entry path: Data tab → Conditional Formatting → New Rule

1. Select the cell range where you want to apply conditional formatting.
2. Click Conditional Formatting → New Rule.
3. In the New Conditional Formatting panel on the right, confirm or change the apply range.
4. Select a rule type such as highlight cells, top or bottom and average, data bars, color scales, or icon sets.
5. Set the condition, enter a value or formula, and choose the display style.
6. Click Create Rule to apply the settings.

Success Criteria

• Interface result: The target range shows the expected formatting based on the rule.
• Next action available: You can edit the rule or add another rule.

Tips While Using

• Common mistake: If the threshold is too high or too low, no cells may be highlighted.
• Environment note: When you use formulas, make sure the references match the worksheet structure.

3. Apply a preset rule quickly

Entry path: Data tab → Conditional Formatting → preset submenu

1. Select the cell range where you want to apply conditional formatting.
2. Click Conditional Formatting and choose a preset category and item, such as Highlight Cells → Greater Than.
3. Enter the condition value in the dialog box.
4. Select or customize the display format.
5. Confirm the setting so matching cells are formatted automatically.

Success Criteria

• Interface result: Matching cells immediately display the selected preset style.
• Next action available: You can add more preset rules or open rule management.

Tips While Using

• Common mistake: If the input value format does not match the cell content type, the result may not match as expected.

4. Manage rules

Entry path: Data tab → Conditional Formatting → Manage Rules

1. Click Conditional Formatting → Manage Rules, or open the management view from the related panel.
2. Review the rule list for the current worksheet or selected range.
3. Double-click a rule or select it to edit the details.
4. Adjust the rule priority as needed.
5. Save the updated settings.

Success Criteria

• Interface result: The rule list is visible, and the updated order or rule content is applied.
• Next action available: You can return to the worksheet and review the display result.

Tips While Using

• Common mistake: Ignoring rule priority can produce a display result that differs from your expectation.

5. Clear rules

Entry path: Data tab → Conditional Formatting → Clear Rules

1. Select the cell range where you want to remove conditional formatting.
2. Click Conditional Formatting → Clear Rules.
3. Choose Clear Rules from Selected Cells or Clear Rules from Entire Sheet.
4. Confirm the change and review the updated formatting.

Success Criteria

• Interface result: Conditional formatting is removed from the selected target area.
• Next action available: You can create a new rule again if needed.

Tips While Using

• Common mistake: Choosing Clear Rules from Entire Sheet by mistake affects all conditional formatting in the current worksheet.