Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #Color 01
- rownumber = 1
- for row in sheet.iter_rows(min_row=2, max_row= sheet.max_row, min_col=1, max_col=4, values_only=True):
- rownumber += 1
- for cell in row:
- if cell is not None and ('Item1','Item2') in str(cell):
- for row2 in sheet.iter_rows (min_row=rownumber, max_row=rownumber, min_col=1, max_col=12):
- for cell1 in row2:
- cell1.fill = color1_fill
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement