Условное форматирование ячеек в XLSX

workbook = xlsxwriter.Workbook('test.xlsx')
worksheet = workbook.add_worksheet()
green = workbook.add_format({'color': 'green'})
bold_red = workbook.add_format({'bold': True, 'color': 'red'})
worksheet.write_rich_string('A1', green,
                            'hello ',
                            bold_red, 'this is bold_red', # style
                            ' and default string')
workbook.close()

import xlsxwriter
 
workbook = xlsxwriter.Workbook('test.xlsx')
worksheet = workbook.add_worksheet()
green = workbook.add_format({'color': 'green'})
bold_red = workbook.add_format({'bold': True, 'color': 'red'})
worksheet.write_rich_string('A1', bold_red, 'he', green,
                            'llo and default string')
workbook.close()

black_ = workbook.add_format({'color': 'black'})
worksheet.write_rich_string('A1', bold_red, 'he', green,
                            'llo', black_, ' and default string')

import xlsxwriter
 
workbook = xlsxwriter.Workbook('reqExample.xlsx')
worksheet = workbook.add_worksheet()
bold_red = workbook.add_format({'bold': True, 'color': 'red'})
bold_blue = workbook.add_format({'bold': False, 'color': 'blue'})
worksheet.write_rich_string('A3',
                            'В три ',
                            bold_red, 'цвета',
                            bold_blue,  # style
                            ' можно :)')
workbook.close()

import xlsxwriter
from xlsxwriter.exceptions import FileCreateError
 
try:
    workbook = xlsxwriter.Workbook('test.xlsx')
except FileCreateError:
    print("Закрой test файл!")
finally:
    workbook = xlsxwriter.Workbook('new.xlsx')
    worksheet = workbook.add_worksheet()
    green = workbook.add_format({'color': 'green'})
    bold_red = workbook.add_format({'bold': True, 'color': 'red'})
    black_ = workbook.add_format({'color': 'black'})
    worksheet.write_rich_string('A1', bold_red, 'he', green,
                                'llo', black_, ' and default string')
    workbook.close()