【Python】按条件添加颜色

import xlwings as xw
import os

app = xw.App(visible=True,add_book=False)
app.display_alerts=False
app.screen_updating=False


def get_file_name(file_dir):
    tmp_lst = []
    for root, dirs, files in os.walk(file_dir):
        for file in files:
            tmp_lst.append(os.path.join(root, file))
    return tmp_lst


green = []
purple = []
yellow = []
blue = []

def read_data(FileName):
    # 1.打开文件
    open_file = xw.Book(FileName)
    # 2.读取某个工作表（第一个表中索引值为0）
    # 打开活动工作表
    sheet = xw.sheets.active
    # 提取某一列数据
    nrows = sheet.used_range.last_cell.row  # 获取一共多少行
    ncols = sheet.used_range.last_cell.column  # 获取一共多少列

    for i in range(1, nrows):
        
        name_rng = sheet[i, 1]
        library_rng = sheet[i, 6]
        combine_rng = sheet[i, 10]
        if name_rng.value == library_rng.value:
            if 0.7 <= combine_rng.value:
                # blue.appe