Highlight Excel Cells With Values 89 or Higher in WPS Spreadsheets
Question details
The user wants to highlight all cells with values 89 or higher across a multi-column range using conditional formatting.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user works with a data range spanning multiple columns and needs to identify qualifying cells quickly.
- Observed behavior
- The user wants the conditional formatting rule to apply to the entire range at once, instead of filtering or formatting each column separately.
Open the workbook in WPS Spreadsheets and identify the exact data range you want to highlight, including all columns and rows.
Apply a Single Conditional Formatting Rule to Highlight Values 89 or Higher
Use this method when you want to highlight qualifying cells across multiple columns in one step without filtering each column.
WPS Spreadsheets applies conditional formatting rules to a selected range, so choosing the full range before creating the rule keeps all columns consistent.
Click and drag across all cells you want to include, such as A2:D100, so the entire range is highlighted.
Go to the Home tab, click Conditional Formatting, and choose New Rule.
In the New Formatting Rule dialog, select Format only cells that contain, leave the first drop-down set to Cell Value, choose greater than or equal to, and enter 89.
Click Format, open the Fill tab or color picker, choose a fill color, and click OK.
Click OK in the New Formatting Rule dialog. The selected cells with values 89 or higher are now highlighted.
Use WPS Spreadsheets to Highlight Values 89 or Higher Across an Entire Range
WPS Spreadsheets lets you apply conditional formatting directly to a selected Excel-compatible worksheet range. Select the full data range, create a cell value rule for greater than or equal to 89, choose a fill color, and WPS Spreadsheets applies the rule across all selected columns without separate filters.
- 1. Download and open WPS Office: Install WPS Office from the official site, open WPS Spreadsheets, and load your .xlsx workbook.
- 2. Select the entire data range: Click and drag across all columns and rows that contain the scores or values you want to evaluate.
- 3. Create a conditional formatting rule: On the Home tab, click Conditional Formatting > New Rule, choose Format only cells that contain, and set Cell Value greater than or equal to 89.
- 4. Choose a fill color and confirm: Click Format, select a fill color, and click OK to apply the rule to the selected range.
Frequently Asked Questions
Can I apply the 89-or-higher rule to multiple columns at once?
Yes. Select the entire range before opening Conditional Formatting, and WPS Spreadsheets applies the rule to every selected cell.
Will the highlighting update automatically when values change?
Yes. Conditional formatting evaluates cells dynamically, so if a value changes to 89 or higher, the fill color appears automatically.
How do I edit or remove the 89-or-higher rule later?
Select the range, go to Home > Conditional Formatting > Manage Rules, choose the rule, and edit or delete it.
Can I use this rule with other thresholds or colors?
Yes. In the New Formatting Rule dialog, enter a different value and choose another fill color before clicking OK.
