How to Turn WPS Spreadsheets Font Red When a Value Is 80:00 or Higher
Question details
The user wants to create a conditional formatting rule in WPS Spreadsheets that automatically changes font color to red when a cell contains a value of 80:00 or higher.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is working with time or numeric data and wants to highlight cells reaching 80:00 or above.
- Observed behavior
- Font color remains unchanged until a conditional formatting rule is applied.
Select the range you want to format and confirm whether the cells store real time values or numeric values. Check the active cell reference before creating the formula rule.
Create a Formula-Based Conditional Formatting Rule to Turn Font Red for Values 80:00 or Higher
Use this method when you want WPS Spreadsheets to automatically apply a red font to time values of 80:00 or greater, or numeric values of 80 or greater.
The formula must match how the value is stored in the cell. If the cell contains a time value, use a time comparison such as =A1>=TIME(80,0,0). If the cell contains a number, use =A1>=80.
Open your WPS Spreadsheets file and select the range where you want the red font to appear, for example A1:A100.
Go to the Home tab and click Conditional Formatting > New Rule.
In the New Formatting Rule dialog, select Use a formula to determine which cells to format.
In the formula box, type =A1>=TIME(80,0,0) for a time value, or =A1>=80 for a numeric value. Adjust A1 to the active cell in your selected range.
Click Format, open the Font tab, set the Color to red, click OK, and then click OK again to save the rule.
Highlight Values of 80:00 or Higher with WPS Spreadsheets Conditional Formatting
WPS Office Spreadsheets includes the same conditional formatting workflow as Excel, so you can create a formula-based rule to turn font red when a cell value is 80:00 or higher without changing files.
- 1. Select the range: Open your spreadsheet in WPS Office and select the cells you want to format.
- 2. Create a new rule: Click Home > Conditional Formatting > New Rule.
- 3. Enter the formula: Choose Use a formula and enter =A1>=TIME(80,0,0) for time values or =A1>=80 for numbers.
- 4. Set red font: Click Format > Font, choose red, and confirm the rule.
Frequently Asked Questions
Why does =A1>=80 not work for 80:00?
80:00 is likely stored as a time value, not the number 80. Use =A1>=TIME(80,0,0) when the cell contains a time, and format the formula cell as time if needed.
Can I apply this rule to an entire column?
Yes. Select the entire column or the specific range, then base the formula on the active cell reference, such as =A1>=TIME(80,0,0). WPS Spreadsheets adjusts the reference for each row.
Will this conditional formatting change the cell background instead of font?
You can choose any formatting. In the Format dialog, use the Font tab for red font, or the Fill tab to add a background color.
Does WPS Spreadsheets support the TIME function for hours over 23?
Yes. WPS Spreadsheets can calculate TIME(80,0,0) as 80 hours. Use a time format such as [h]:mm to display values above 24 hours correctly.
