How to Use WPS Conditional Formatting on macOS

This how-to guide includes 8 topics, with 8 free topics and 0 membership-related topics, so you can jump directly from the index to the task you need.

How-to Index

How-to Guide

1. Highlight Cells Rules

Entry path: Home → Conditional Formatting → Highlight Cells Rules

1. Select the cell range where you want to apply conditional formatting.
2. Click the Home tab.
3. Open the Conditional Formatting menu and select Highlight Cells Rules.
4. Choose a rule based on values, text, dates, or similar conditions, then finish the setup.

Success Criteria

• Cells that meet the condition are highlighted automatically.
• The original cell content remains unchanged.

Tips While Using

• Select the target range before creating the rule so the format applies to the correct area.

2. Top/Bottom Rules

Entry path: Home → Conditional Formatting → Top/Bottom Rules

1. Select the cell range you want to analyze.
2. Click the Home tab.
3. Open the Conditional Formatting menu and select Top/Bottom Rules.
4. Choose a rule such as Top N, Bottom N, Above Average, or Below Average.

Success Criteria

• Important items in the selected range are marked quickly.
• High values, low values, or average-based results are easier to review.

Tips While Using

• Results update automatically when the source data changes.

3. Data Bars

Entry path: Home → Conditional Formatting → Data Bars

1. Select the numeric cell range you want to compare.
2. Click the Home tab.
3. Open the Conditional Formatting menu and select Data Bars.
4. Choose a suitable data bar style.

Success Criteria

• In-cell bars appear based on value size.
• Differences between values are easier to compare visually.

Tips While Using

• Data Bars work better with continuous numeric data than with text-only content.

4. Color Scales

Entry path: Home → Conditional Formatting → Color Scales

1. Select the cell range where you want to show distribution or trends.
2. Click the Home tab.
3. Open the Conditional Formatting menu and select Color Scales.
4. Choose a color gradient scheme.

Success Criteria

• Cells in the range show different color intensity based on value levels.
• Distribution and trends are easier to understand.

Tips While Using

• Color Scales are useful for overall patterns, but they do not replace exact numeric reading.

5. Icon Sets

Entry path: Home → Conditional Formatting → Icon Sets

1. Select the cell range you want to classify.
2. Click the Home tab.
3. Open the Conditional Formatting menu and select Icon Sets.
4. Choose an icon style such as arrows, flags, or traffic lights.

Success Criteria

• Icons appear in cells to show level or trend.
• Classification results are easier to identify quickly.

Tips While Using

• Icon Sets are useful for level-based review and are clearer when paired with numeric values.

6. Create a New Rule

Entry path: Home → Conditional Formatting → New Rule

1. Select the cell range where you want to create a rule.
2. Click the Home tab.
3. Open the Conditional Formatting menu and select New Rule.
4. Set the rule with formulas, rankings, duplicate values, or other conditions, then save it.

Success Criteria

• The custom rule takes effect.
• The target range displays the expected format based on your condition.

Tips While Using

• When you use a formula rule, make sure the references match the target range.

7. Clear Rules

Entry path: Home → Conditional Formatting → Clear Rules

1. Select the cell range where you want to remove conditional formatting.
2. Click the Home tab.
3. Open the Conditional Formatting menu and select Clear Rules.
4. Choose whether to clear rules from the selected cells or the entire worksheet.

Success Criteria

• The conditional formatting style is removed.
• The original cell data is still there.

Tips While Using

• Clearing rules changes formatting only and does not delete cell content.

8. Manage Conditional Formatting Rules

Entry path: Home → Conditional Formatting → Manage Rules

1. Select a range that already has conditional formatting.
2. Click the Home tab.
3. Open the Conditional Formatting menu and select Manage Rules.
4. Review, edit, or delete existing rules in the rule manager.
5. Reorder rule priority as needed.

Success Criteria

• The current rule list is visible and editable.
• Updated rule order or rule content takes effect.

Tips While Using

• When multiple rules exist, priority affects the final display result.