How to Apply Conditional Formatting Based on TRUE or FALSE Results in WPS Spreadsheets
Question details
The user wants to apply green and red conditional formatting rules to cells that return TRUE or FALSE after checking a range against specified criteria.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A user has a range of cells that already evaluate to TRUE or FALSE and wants to color-code the results to quickly identify matches and non-matches.
- Observed behavior
- The TRUE/FALSE results are visible, but the cells do not yet show green for TRUE and red for FALSE.
Open the workbook in WPS Spreadsheets and select the exact range that contains the TRUE/FALSE results. Make sure the first cell in that range is the reference used in the conditional formatting formula.
Use Formula-Based Rules to Color TRUE and FALSE Cells
Use this solution when you want dynamic green and red formatting that follows each row's TRUE or FALSE result automatically.
WPS Spreadsheets evaluates a formula-based condition from the first cell in the selected range and adjusts relative references automatically for the remaining cells.
Select the cells that contain the TRUE/FALSE results, for example A2:A10.
In WPS Spreadsheets, go to the Home tab, click Conditional Formatting, and choose New Rule.
Select Use a formula to determine which cells to format, enter =A2=TRUE, click Format, choose a green fill or font, and confirm with OK.
Click Conditional Formatting > New Rule again, use =A2=FALSE as the formula, choose a red format, and confirm.
Verify that both rules apply to the same selected range and that the formula uses the first cell as a relative reference, such as A2.
Apply TRUE/FALSE Conditional Formatting in WPS Spreadsheets
Use WPS Spreadsheets to create formula-based conditional formatting rules that automatically fill TRUE cells green and FALSE cells red, without macros or add-ins.
- 1. Open the Workbook in WPS Spreadsheets: Launch WPS Office, open the .xlsx workbook that contains the TRUE/FALSE results, and click the worksheet where you want the formatting.
- 2. Select the Result Range: Highlight the cells that return TRUE or FALSE, starting with the first row you want to evaluate.
- 3. Open Conditional Formatting: On the Home tab, click Conditional Formatting, then select New Rule.
- 4. Add the TRUE and FALSE Formulas: Choose Use a formula to determine which cells to format, create =A2=TRUE with a green format and =A2=FALSE with a red format, then apply both rules to the same range.
Frequently Asked Questions
Can I use =A2 instead of =A2=TRUE for the green rule?
Yes. Since WPS Spreadsheets treats TRUE as a logical value, =A2 works for TRUE cells. Use =A2=FALSE or =NOT(A2) for FALSE cells.
Why do my rules use A2 even though my data starts in A5?
The formula must use the first cell in the selected range as a relative reference. If you select A5:A100, start the formula with =A5=TRUE so WPS can adjust it correctly for each row.
Can I edit these rules after they are created?
Yes. Select the range, go to Home > Conditional Formatting > Manage Rules, then select a rule and choose Edit Rule to change the formula or format.
Will these conditional formatting rules remain when I open the file in Microsoft Excel?
Yes. WPS Spreadsheets uses the same .xlsx format, so formula-based conditional formatting rules travel between WPS Office and Microsoft Excel.
