import pandas as pd
df = pd.read_excel('disk.xlsx')
def color(value):
if value == 'File Uploaded!' :
color = 'green'
else:
return
return f'background-color: {color}'
df.style.applymap(color, subset=['file_status'])
df.to_excel('disk.xlsx',index=None)
Asked
Active
Viewed 28 times
0