How to Make Excel Cells Red When Values Are 9 or Higher
Question details
The user wants to automatically format cell text to red when the numerical value in the cell is 9 or greater.

- Product
- Excel 2019
- Device & OS
- not provided
- Scenario
- Visualizing data based on specific numerical thresholds to easily identify values meeting or exceeding a target.
- Observed behavior
- The user needs to set up a conditional formatting rule to automatically apply red font formatting to values meeting the greater than or equal to criteria.
Ensure your data consists of numerical values rather than text strings, as conditional formatting for value thresholds only functions correctly with numbers. Select the specific range of cells you want to format before configuring the rule.
Use Conditional Formatting to Highlight Cells
Apply Excel's built-in Conditional Formatting feature to automatically change font or fill color based on the value inside the cell.
Conditional formatting dynamically updates cell styles based on the data. By setting a 'Greater Than or Equal To' rule, any existing or future data in the selected range that is 9 or above will automatically be colored red.
Click and drag to select all the cells you want to monitor and format.
Navigate to the 'Home' tab on the top ribbon, find the 'Styles' group, and click on 'Conditional Formatting'.
Hover your mouse over 'Highlight Cells Rules'. Since 'Greater Than' is the default quick option, click on 'More Rules...' at the bottom of the submenu to include the exact value of 9.
In the dialog box, select 'Format only cells that contain'. Set the dropdowns to 'Cell Value' and 'greater than or equal to', then type '9' in the value box.
Click the 'Format' button, go to the 'Font' tab (or 'Fill' tab if you want the background colored), and select the color red. Click 'OK' on both dialog boxes to apply the rule.

Highlight Data Instantly with WPS Spreadsheet
You can easily apply conditional formatting in WPS Spreadsheet to highlight values greater than or equal to 9. WPS Office offers a highly compatible and intuitive interface for all your data visualization needs, entirely for free.
- 1. Select Cells: Open your worksheet in WPS Spreadsheet and highlight the data range.
- 2. Open Conditional Formatting: Go to the Home tab and click on the 'Conditional Formatting' icon.
- 3. Apply Highlight Rule: Select Highlight Cells Rules > More Rules. Choose 'greater than or equal to', enter 9, and set the format to Red text.
- 4. Confirm: Click OK to instantly apply the dynamic formatting to your spreadsheet.

Frequently Asked Questions
Can I highlight the entire row instead of just the single cell?
Yes. To highlight the entire row, select your entire data table (excluding headers), go to Conditional Formatting > New Rule > Use a formula to determine which cells to format. Enter a formula like `=$A2>=9` (assuming the value you are checking is in column A, starting at row 2) and apply your red format. The dollar sign locks the column so the whole row formats based on column A.
Why isn't my conditional formatting working on the numbers?
Your numbers might be stored as text. Select the cells, click the yellow warning icon that appears, and choose 'Convert to Number'. Alternatively, you can type '1' in an empty cell, copy it, select your target numbers, right-click, choose 'Paste Special', select 'Multiply', and click OK.
How do I remove the red conditional formatting later?
Select the cells containing the formatting, go to the Home tab > Conditional Formatting > Clear Rules, and choose either 'Clear Rules from Selected Cells' or 'Clear Rules from Entire Sheet' to remove the styling.




