How to Use WPS Conditional Formatting on Windows

Use WPS Conditional Formatting through 5 topics, including opening the feature menu, creating a new rule, using preset rules, managing rules, and clearing rules.

How-to Index

How-to Guide

1. Open the feature menu and preset categories

Feature 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, including Highlight Cells Rules, Top/Bottom/Average, Data Bars, Color Scales, Icon Sets, New Rule, Manage Rules, and Clear Rules.
4. Choose the rule category that matches your data type and goal.

Success Criteria

• Interface result: The Conditional Formatting menu opens and the rule categories are visible.
• Next action available: You can continue to a preset rule, New Rule, or Manage Rules.

Tips While Using

• Common mistake: If you do not select the target range first, the rule may not apply to the intended cells.
• Environment note: You need edit access to the worksheet.

2. Create a new rule

Feature path: Data tab → Conditional Formatting → New Rule

1. Select the cell range where you want to apply the rule.
2. Click Conditional Formatting → New Rule.
3. In the New Conditional Formatting panel, confirm or change the apply range.
4. Choose a rule type such as Highlight Cells Rules, Top/Bottom/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 it. If needed, click Reset to clear the current setup.

Success Criteria

• Interface result: The selected range shows formatting changes where the condition is met.
• Next action available: You can return to the worksheet or continue to Manage Rules for more adjustments.

Tips While Using

• Common mistake: An incorrect apply range can leave part of the target area outside the rule.
• Environment note: If you use a formula rule, make sure the formula logic and references are correct.

3. Use preset rules quickly

Feature path: Data tab → Conditional Formatting → preset category submenu

1. Select the cell range where you want to apply Conditional Formatting.
2. Click Conditional Formatting and choose a preset category, such as Highlight Cells Rules → Greater Than.
3. Enter the condition value in the pop-up box.
4. Choose a preset display format or adjust the style as needed.
5. Confirm the rule so matching cells are formatted automatically.

Success Criteria

• Interface result: Matching cells are highlighted immediately or show the selected style.
• Next action available: You can add more rules to build layered formatting results.

Tips While Using

• Common mistake: If the condition value is too high or too low, no cells may appear highlighted.
• Environment note: Different preset rules fit different data types, so choose the rule that matches text, dates, or numbers.

4. Manage rules

Feature path: Data tab → Conditional Formatting → Manage Rules

1. Click Conditional Formatting → Manage Rules, or open the management entry from the related panel.
2. Review the rule list for the current worksheet or current selection.
3. Select a rule to edit its condition or display style.
4. Use move-up or move-down controls to adjust rule priority.
5. If needed, create another rule from the management interface.

Success Criteria

• Interface result: The rule list is visible, and worksheet formatting updates after changes are saved.
• Next action available: You can continue editing, reordering, or adding rules.

Tips While Using

• Common mistake: When multiple rules match the same cells, priority order affects the final display.
• Environment note: Check whether you are viewing worksheet rules or selection rules before editing.

5. Clear rules

Feature 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. Review the worksheet to confirm that the formatting has been removed from the intended area.

Success Criteria

• Interface result: The target area no longer shows the previous Conditional Formatting result.
• Next action available: You can create a new rule again if needed.

Tips While Using

• Common mistake: Choosing Clear Rules from Entire Sheet removes all Conditional Formatting rules in the current worksheet.
• Environment note: If you want to keep some rules, review them in Manage Rules before clearing.