How to highlight specific data in excel using conditional formatting

How to use conditional formatting to highlight specific data in Excel? Excel is one of the most commonly used data processing tools nowadays. Some users want to know how to highlight data through conditional formatting. For example, if the value is greater than a certain value, it will be displayed in red, and the others will be in another color. Next, I will introduce to you the specific details. Method steps. Setting method 1. First open the Excel document on the computer, and then select the cell data according to the arrow in the figure below.

2. According to the arrow in the picture below, find and click the [Conditional Formatting] icon.

3. In the expanded drop-down list, click the [Highlight Rule] option as pointed by the arrow in the picture below.

4. Set rules according to needs. According to the arrow in the picture below, the editor takes [greater than] as an example.

5. In the pop-up window, first set the value as required, and then click the [OK] option according to the arrow in the picture below.

6. Finally, as shown in the figure below, the data that meets the conditions are successfully highlighted.

The above is the detailed content of How to highlight specific data in excel using conditional formatting. For more information, please follow other related articles on the PHP Chinese website!