Here's a scenario from my code:

bgNum = [0,0,0,36,35,0,36]
for bgNumIdx, bgNumVal in enumerate(bgNum):
    if bgNumVal == 36:
        format.set_bg_color('yellow')
    else:
        #set bg color to no-fill

Else statement should set background-color to no-fill.

CodePudding user response：

With some trial and error, this is what I got:

cell_format.set_bg_color(False)