Nov-05-2019, 09:19 AM
Hello,
my code is not working and I don't know why.
I need change font size when value in cell is '2', for A1 to A100.
my code is not working and I don't know why.
I need change font size when value in cell is '2', for A1 to A100.
# load libs from openpyxl import load_workbook from openpyxl.styles import colors from openpyxl.styles import Font, Color # load xlsx wb = load_workbook('uh201910.xlsx') ws = wb.active # for A1 to A100, if Ax is 2 then change font size to 124 for Ax cells = ws['A1':'A100'] for i in cells: if i == 2: ws['i'] = Font(size=124) # saving wb.save('styles.xlsx')Thank you.