How to Use WPS Conditional Formatting on Windows

Use Conditional Formatting with 8 how-to topics in WPS Spreadsheets; 8 items are available without membership and 0 items are membership-related.

How-to Index

How-to Guide

1. Highlight Cells Rules

Feature 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. Set the rule based on values, text, dates, or other supported conditions.

Success Criteria

• Cells that meet the condition are highlighted automatically.
• The display updates when the cell content changes.

Tips While Using

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

2. Top/Bottom Rules

Feature path: Home → Conditional Formatting → Top/Bottom 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 Top/Bottom Rules.
4. Choose a rule such as top items, bottom items, above average, or below average.

Success Criteria

• The target items in the selected range are marked automatically.
• You can identify high-ranking, low-ranking, or above-average data more quickly.

Tips While Using

• The result updates automatically when the underlying data changes.

3. Data Bars

Feature path: Home → Conditional Formatting → Data Bars

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

Success Criteria

• In-cell bars appear and reflect the relative size of the values.
• Differences between values can be compared visually.

Tips While Using

• Data Bars are especially suitable for continuous numeric data.

4. Color Scales

Feature path: Home → Conditional Formatting → Color Scales

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

Success Criteria

• Cells display different colors or intensities based on their values.
• Distribution and trends are easier to identify through color changes.

Tips While Using

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

5. Icon Sets

Feature path: Home → Conditional Formatting → Icon Sets

1. Select the cell range where you want to apply an icon set.
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 the cells to show level or trend.
• Different data categories can be distinguished more quickly.

Tips While Using

• Icon Sets are useful for status indication and level-based comparison.

6. New Rule

Feature path: Home → Conditional Formatting → New Rule

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 New Rule.
4. Set a custom rule with formulas, rankings, duplicate values, or other supported logic, then save it.

Success Criteria

• The custom rule takes effect.
• The selected range displays the expected format based on the rule.

Tips While Using

• When you use formula-based rules, confirm that the references and logic are correct.

7. Clear Rules

Feature 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

• Conditional formatting is removed from the target area.
• The original cell data remains unchanged.

Tips While Using

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

8. Manage Conditional Formatting Rules

Feature path: Home → Conditional Formatting → Manage Rules

1. Select the cell range whose rules you want to review or adjust.
2. Click the Home tab.
3. Open the Conditional Formatting menu and select Manage Rules.
4. Review, edit, delete, or reorder the rules in the rules manager.

Success Criteria

• The current rule list is visible for the selected area.
• Any changes to rule order or content take effect.

Tips While Using

• When multiple rules exist, their priority order can affect the final display.