Highlight cells greater than a specific value

November 4, 2021
92 Views 0

Graphic skills

It will format cells filled with a value greater than a specific number. In the following example, Conditional Formatting helps us highlight cells greater than $700,000.

1. Select an array for conditional formatting.

2. Go to the Home tab click Conditional Formatting.

Highlight cells greater than a specific value (1).gif

 

3. Choose Highlight Cells Rules  choose Greater than option from the drop-down menu.

4. Enter '700,000' in the Greater than input box. Choose a format from the drop-down menu.

5. Click OK. The cells greater than 700,000 will be highlighted with the specific color.

Highlight cells greater than a specific value (2).gif

Condition example 1: Highlight cells GREATER THAN a specific value


To be Office Excel advanced, you could learn relevant skills of WPS Office Spreadsheet online in WPS Academy.