How Excel tables Filter by color

　　The Excel color filtering steps are as follows:

1. Start Excel and open the worksheet, the text in the "On-Job" column of the worksheet has been set to different colors according to different types, as shown in Figure 1. On the Data tab, in the Sort and filter group, click the Filter button to enter the AutoFilter status.

Figure 1 Text sets a different color

2, in the "on-hand" cell Click on the Right triangle button to open the AutoFilter list, select the Filter by Color option, select the Font color option in the open subordinate list, select Red here, and click OK when you finish setting, as shown in Figure 2.

Figure 2 Color selection

2, at this time the color of the work table is red data is filtered out, as shown in Figure 3.