2. First, select a single data or a whole row and column to set, and then open the conditional format, as shown below.
3. Here, you need to select cell values and formulas as needed. After selecting the cell data, you need to select its range value.
4. After completing the form, set the following format. Click Format to display the chart below. After selecting the data representation, click OK.
5. Conditional formats can be distinguished by setting three conditions for the same data selected at the same time.