WPS Conditional Formatting on Windows FAQ

Common questions about WPS Conditional Formatting on Windows include rules not taking effect, unexpected display results, and whether formatting stays with the file across devices.

FAQ

Why does Conditional Formatting not show colors or icons after I set a rule?

1. Check whether you selected the correct cell range before creating the rule.
2. Review the condition value, text match, or formula to make sure it matches the actual data.
3. Open Manage Rules and confirm that the rule still exists and the apply range is correct.
4. If you used a formula rule, check whether the references should be absolute or relative.

Which format is shown when multiple rules match the same cells?

1. Open Manage Rules from the Conditional Formatting menu.
2. Review the order of the rules in the list.
3. Move the more important rule higher in the priority order.
4. Return to the worksheet and confirm that the final result matches your expectation.

Does Conditional Formatting stay with the spreadsheet file after saving?

1. Save the spreadsheet after you finish setting the rules.
2. Reopen the file and check whether the rules are still present.
3. Open the same file on another device or with another account and review whether the formatting still appears.
4. If you want consistent results, share the saved spreadsheet file directly.

Glossary