How to Use WPS Conditional Formatting on Android

This section includes 4 how-to topics for Android spreadsheets; choose a task from the index and follow the steps to complete it.

How-to Index

How-to Guide

1. Add conditional formatting

Feature entry: Select cells → Tools → Data → Conditional Formatting

1. Select the cells or data range where you want to apply conditional formatting.
2. Tap the Tools button at the bottom.
3. Switch to the Data tab.
4. Tap Conditional Formatting to open the settings panel.
5. Set the condition and style you need, then save the rule.

Success Criteria

• Interface result: The selected range shows the expected highlight style or formatting change.
• Next action available: You can continue to add, edit, or remove 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 to work in an editable spreadsheet.

2. Add or delete existing rules

Feature entry: Select cells → Tools → Data → Conditional Formatting → Manage Existing Rules

1. Select the cell range where rules are already applied or will be applied.
2. Open the Conditional Formatting panel.
3. Tap Manage Existing Rules.
4. Add a new rule or delete a rule you no longer need.

Success Criteria

• Interface result: The rule list shows the new rule, or the removed rule no longer appears.
• Next action available: You can continue adjusting other rules.

Tips While Using

• Common mistake: Deleting a rule without checking its applied range may affect the display of other cells.

3. Clear conditional formatting from an entire worksheet

Feature entry: Tools → Home → Conditional Formatting → Clear Rules

1. Open the worksheet where you want to remove conditional formatting.
2. Tap Tools.
3. Go to Home and open Conditional Formatting.
4. Tap Clear Rules.
5. Select Clear Rules from Entire Sheet.

Success Criteria

• Interface result: Conditional formatting styles are removed from the worksheet.
• Next action available: You can create new conditional formatting rules again.

Tips While Using

• Common mistake: If you only want to clear part of the sheet, do not choose the entire worksheet option.

4. Handle rule conflicts and priority

Feature entry: Conditional Formatting → Manage Rules

1. Open the Manage Rules panel.
2. Review the order of rules in the list.
3. Identify the rules that conflict with each other.
4. Adjust rule priority or remove conflicting rules.

Success Criteria

• Interface result: Target cells display the final style you expect.
• Next action available: You can keep using the current priority setup for later rules.

Tips While Using

• Common mistake: When multiple rules match at the same time, not checking priority can cause unexpected display results.