How to Highlight Excel Values Greater Than 75 Percent in WPS Spreadsheets
Question details
The user needs to apply conditional formatting so percentage values greater than 75% are highlighted in a WPS Spreadsheets workbook.

- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A user tracks achieved marks, maximum marks, and percentages for subjects such as electives, language, physical education, mentoring, and English, and wants to quickly identify subjects above 75%.
- Observed behavior
- By default, all percentage cells have the same formatting, making it difficult to spot values above 75% at a glance.
Open your WPS Spreadsheets workbook and make sure the percentage column contains numeric values formatted as Percentage, not text. If needed, select the cells, press Ctrl+1, and choose Percentage before creating the rule.
Use Conditional Formatting to Highlight Values Greater Than 75%
Use this solution when your percentage column already contains numeric percentage values and you want a quick visual highlight for every subject above 75%.
This built-in rule compares each selected cell to 75% and applies the chosen fill and font only to values strictly greater than 75%. If your data is stored as text or only contains achieved marks and maximum marks, create a separate numeric percentage column first.
Select the cells that contain the percentages you want to test, for example D2:D6 under the "Actual %" column.
Click Home > Conditional Formatting > Highlight Cells Rules > Greater Than.
In the Greater Than dialog, type 75% or 0.75 in the value box. WPS Spreadsheets accepts either form when the selected cells are numeric percentages.
Choose a preset such as Light Red Fill with Dark Red Text, or create a custom format, then click OK.

Convert Percentage Values Stored as Text Before Applying the Rule
Use this solution when conditional formatting does not highlight any cells, often because the percentage column contains text values instead of numeric percentages.
Highlight Values Above 75% in WPS Spreadsheets with Conditional Formatting
WPS Spreadsheets includes the same conditional formatting workflow as Excel, so you can open your workbook, apply the Greater Than rule to a percentage column, and save it as a fully compatible .xlsx file without losing formatting.
- 1. Open your workbook in WPS Spreadsheets: Download and install WPS Office, open WPS Spreadsheets, and load the Excel workbook that contains the subject marks and percentage column.
- 2. Select the percentage range: Select the percentage cells you want to evaluate, such as the "Actual %" column.
- 3. Apply the Greater Than rule: Click Home > Conditional Formatting > Highlight Cells Rules > Greater Than, enter 75% or 0.75, choose a highlight, and click OK.
- 4. Save in Excel-compatible format: Save or export the workbook as .xlsx so the conditional formatting remains intact in Microsoft Excel.

Frequently Asked Questions
What is the difference between Greater Than 75% and greater than or equal to 75%?
Greater Than 75% only highlights values strictly above 75%. If you also want 75% included, use Home > Conditional Formatting > Highlight Cells Rules > Greater Than or Equal To.
Why are my percentage cells not highlighting after I set the rule?
The most common reason is that the percentage cells are stored as text instead of numeric percentages. Select the range, set Home > Number Format to Percentage, and then reapply the Greater Than rule.
Can I enter 0.75 instead of 75% in the Greater Than dialog?
Yes. If the selected cells contain numeric percentages, WPS Spreadsheets treats 0.75 and 75% as the same value in conditional formatting.
Does WPS Spreadsheets preserve this conditional formatting when saving as an Excel file?
Yes. Save the workbook as .xlsx and the Greater Than conditional formatting is retained when the file is opened in Microsoft Excel.
Can I highlight percentages above 75% while keeping achieved marks and maximum marks separate?
Yes. Store achieved marks, maximum marks, and percentages in separate columns, then select only the percentage column and apply Home > Conditional Formatting > Highlight Cells Rules > Greater Than.




