https://iknow-pic.cdn.bcebos.com/b8014a90f603738de05f971abc1bb051f819ecf5

2、開啟後新建一些資料，其中單元格包含兩種顏色，如下圖所示；

https://iknow-pic.cdn.bcebos.com/3ac79f3df8dcd100bc9563197d8b4710b9122ff8

https://iknow-pic.cdn.bcebos.com/ac345982b2b7d0a2bf8e9fa5c4ef76094b369a47

4、在資料選單選擇自動篩選，如下圖所示；

https://iknow-pic.cdn.bcebos.com/43a7d933c895d143808a7e1b7cf082025aaf070d

https://iknow-pic.cdn.bcebos.com/342ac65c10385343583102199c13b07eca808808

6、根據個人喜好選擇靠前的顏色，如下圖所示；

https://iknow-pic.cdn.bcebos.com/32fa828ba61ea8d30593ea3c980a304e251f5851

https://iknow-pic.cdn.bcebos.com/b21bb051f819861864f771bc45ed2e738bd4e652