我需要，使用openpyxl，循环for，以根据单元格中的值插入随机背景色吗？

if cell_value = 1 then backgroundcolor = blue (or random color)
if cell_value = 2 then backgroundcolor = red (or random color)
if cell_value = 3 then backgroundcolor = white (or random color)

... etc.

我尝试过。

wb = load_workbook(file)
ws = wb.active

from openpyxl import load_workbook
from openpyxl.styles import PatternFill

for row in ws.iter_rows("A"):
    for cell in row:
        if cell.value == '1':
            ws.cell(row=cell.row,column=1).fill = PatternFill(fgColor="ff33ff",fill_type = "solid")
        elif cell.value == '2':
            ws.cell(row=cell.row,column=1).fill = PatternFill(fgColor="33ffff",fill_type = "solid")
        elif cell.value == '3':
            ws.cell(row=cell.row,column=1).fill = PatternFill(fgColor="ffff55",fill_type = "solid")
        elif cell.value == '4':
            ws.cell(row=cell.row,column=1).fill = PatternFill(fgColor="ff55ff",fill_type = "solid")

...

它正在工作，但是我怎样做循环呢？以1000个值为例。谢谢。

PS：请给我看看代码。