How to Turn Cell Text Red When Value Is No in WPS Spreadsheets
Question details
The user needs to configure conditional formatting in WPS Spreadsheets so a cell's font color automatically becomes red whenever the cell value equals No.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is working with a worksheet and wants to highlight all cells containing the value No in red, without manually changing each cell.
- Observed behavior
- Cells containing No currently remain in the default font color; the user wants them to be formatted automatically when the value appears.
Open the worksheet in WPS Spreadsheets and select the cell or range to format. Make sure the target cells use the exact text No if you plan to use the Equal To rule; the rule colors only cells whose values match.
Use Highlight Cells Rules to Turn No Red
Fastest and easiest option for a single cell, a list, or a table where all cells containing No should turn red.
The Equal To rule compares the selected cells with the text No and applies the chosen font color automatically whenever the value matches. This method does not require writing formulas and works well for fixed ranges.
Select the cell or range in your WPS Spreadsheets worksheet where you want the red text to appear.
Go to the Home tab, click Conditional Formatting, then choose Highlight Cells Rules and select Equal To.
In the Equal To dialog, type No in the input box.
Open the format dropdown and choose Red Text or a custom format with red font, then click OK to apply the rule.
Use a Formula Rule for a Dynamic Range
Use this if you want to format an entire column or a large range based on the value in a specific column, such as =$A1="No".
Apply Red Font to No Values with WPS Spreadsheets
Open your workbook in WPS Spreadsheets and use the built-in conditional formatting tools to automatically color cells red when their value equals No, with no formula required.
- 1. Download WPS Office: Get WPS Office from the official WPS website and install it on your computer.
- 2. Open your workbook: Launch WPS Spreadsheets and open the XLSX or XLS file that contains the cells you want to format.
- 3. Select the target range: Click and drag to select the cell or range where No values should turn red.
- 4. Create the highlight rule: Go to Home > Conditional Formatting > Highlight Cells Rules > Equal To, enter No, and choose a red font format.
- 5. Save your file: Press Ctrl+S or click File > Save to keep the conditional formatting rule.
Frequently Asked Questions
Does the red font update automatically if a cell changes to No later?
Yes. Once a conditional formatting rule is applied, WPS Spreadsheets recalculates the rule when cell contents change. If another cell in the formatted range changes to No, it will use the red font automatically.
Can I apply the rule to an entire column without selecting every row?
Yes. Select the column header or the entire column range, then use a formula rule such as =$A1="No". Make sure the formula uses the active cell's row reference so the rule shifts correctly down the column.
Will the Equal To rule also highlight lowercase no?
The Equal To text comparison in WPS Spreadsheets is not case-sensitive, so it generally matches no, No, and NO. If you need case-sensitive matching, use a formula rule with the EXACT function.
How do I remove the red text rule later?
Select the formatted range, go to Home > Conditional Formatting > Clear Rules, and choose Clear Rules from Selected Cells or Clear Rules from Entire Sheet.
Can I change the color from red to another color?
Yes. After creating the rule, select the range and go to Conditional Formatting > Manage Rules, edit the rule, click Format, and choose a different font color.
