1. What is a conditional format?
Conditional formatting is a function in Excel, which can automatically change the format of cells according to specific conditions, such as font color, background color, border and so on. By using conditional format, we can quickly visualize the data in order to better understand and analyze the data.
Second, how to use conditional formatting to set the cell color?
1. Open Excel and select the range of cells that need conditional formatting.
2. In the menu bar of Excel, click the Start tab, find the conditional formatting button in the style group, click the drop-down arrow, and select New Rule in the pop-up menu.
3. In the new format rule dialog box that pops up, select Use Formula to determine the cells to be formatted.
4. Enter the formula for the conditional format you want to set in the Format Value box. For example, if you want to set the color according to whether the cell value is greater than 10, you can enter the formula "= a1>; 10"。
5. Select the format to be applied in the Format box, such as font color, background color, etc.
6. Click OK to apply conditional formatting.
Third, common examples of conditional formats.
1. Sets the color according to the value.
If you want to set the color according to the size of the value in the cell, you can use the Data Column function of conditional format. The specific operation steps are as follows:
(1) Select the range of cells that need to be formatted conditionally.
(2) Click the Conditional Format button in the Start tab and select the data column from the drop-down menu.
(3) In the "Data Bar" dialog box that pops up, select "Color Code" and set the minimum and maximum values of colors.
(4) Click OK to apply the conditional format.
2. Set the color according to the text content
If you want to set the color according to the text content in the cell, you can use the "Text Inclusion" function of conditional format. The specific operation steps are as follows:
(1) Select the range of cells that need to be formatted conditionally.
(2) Click the Conditional Format button in the Start tab and select New Rule from the drop-down menu.
(3) In the New Format Rule dialog box, select only specific text.
(4) Enter the text content to be set in the format value box.
(5) Select the format to be applied in the format box.
(6) Click OK to apply the conditional format.