Currently, many netizens use wps tables at work, and it is very convenient to statistically analyze data. So how to set negative numbers to automatically turn red in WPS tables? Detailed steps are explained below.

1. Use the mouse to select the wps table range to be marked with negative numbers.

2. Open the Home tab of the wps form.

3. Click the [Conditional Formatting] button as shown in the Home tab.

4. Click the [Less Than] option in the [Highlight Cell Rules] submenu in the drop-down menu.

5. Enter 0 in the pop-up dialog box.

6. The red text option should remain selected at [Set as] in the dialog box.

7. After clicking the OK button in the dialog box, the negative numbers in the selected table range will turn red.

Friends who still don’t know the related operations of setting negative numbers in WPS tables to automatically turn red, don’t miss this article brought by the editor.