How to Use WPS Conditional Formatting on macOS

Use WPS Conditional Formatting through 5 how-to topics, all available without membership; choose a topic from the index and follow the menu path and steps.

How-to Index

How-to Guide

1. Open the Conditional Formatting menu and review preset categories

Feature path: Data → Conditional Formatting

1. Select the cell range where you want to work with conditional formatting.
2. Click Conditional Formatting on the Data tab.
3. Review the preset categories in the drop-down menu, including Highlight Cells, Top/Bottom/Average, Data Bars, Color Scales, Icon Sets, New Rule, Manage Rules, and Clear Rules.
4. Choose the next action based on the type of rule you want to apply.

Success Criteria

• Interface result: You can see the Conditional Formatting menu and its rule categories.
• 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 applied range may not match what you expect.

2. Create a new conditional formatting rule

Feature path: Data → 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 on the right, confirm or edit the target range.
4. Select a rule type such as Highlight Cells, Top/Bottom/Average, Data Bars, Color Scales, or Icon Sets.
5. Set the condition field, comparison operator, and the value or formula.
6. Choose a preset style, or customize bold, italic, underline, font color, border, and fill color.
7. Click Create Rule to apply the rule. If needed, click Reset to clear the current setup.

Success Criteria

• Interface result: The target range shows the expected formatting when the condition is met.
• Next action available: You can continue editing the rule or open rule management.

Tips While Using

• Common mistake: If the condition value or formula is incorrect, no cells may match the rule.
• Environment note: When you use a formula, make sure the references match the target range.

3. Apply a preset conditional formatting rule quickly

Feature path: Data → Conditional Formatting → Preset submenu

1. Select the cell range where you want to apply formatting.
2. Click Conditional Formatting and choose a preset rule, 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 format.
• Next action available: You can add more rules or open rule management.

Tips While Using

• Common mistake: If the entered value does not match the actual data type in the cells, the highlight result may not appear correctly.

4. Manage conditional formatting rules

Feature path: Data → Conditional Formatting → Manage Rules

1. Click Conditional Formatting → Manage Rules, or click Manage Conditional Formatting at the bottom of the new rule panel.
2. Review the list of rules for the current worksheet or current selection.
3. Double-click a rule to edit its condition and display format.
4. Move a rule up or down to change its priority.
5. If needed, click New Rule to add another rule from the management window.

Success Criteria

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

Tips While Using

• Common mistake: When multiple rules match the same cells, rule order affects the final display result.

5. Clear conditional formatting rules

Feature path: Data → 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 action to remove the rules from the selected scope.

Success Criteria

• Interface result: Conditional formatting is removed from the selected range or the current worksheet.
• Next action available: You can create new rules again if needed.

Tips While Using

• Common mistake: Choosing Clear Rules from Entire Sheet removes all conditional formatting in the current worksheet, so confirm the scope first.