Color Dataframe Based On Some Condition

I would like to color the dataframe based on the condition below LL UL col_1 col_2 col_3 col_4 1 0 10 5 -6 13 46 2 3 12 0 5

Solution 1:

Compare all columns by LL and UL columns and return style DataFrame filled by numpy.select:

def highlight(x):
    c1 ='background-color: red'
    c2 ='background-color: green'
    c3 ='' 
    m1 = x.lt(x['LL'], axis=0)
    m2 = x.gt(x['UL'], axis=0)
    #if necessary setfirst2 columns toFalse
    m1.iloc[:, :2] =False
    m2.iloc[:, :2] =Falseout= np.select([m1, m2], [c1, c2], default=c3)
    return pd.DataFrame(out, index=x.index, columns=x.columns)

df.style.apply(highlight, axis=None)

---

df.style.apply(highlight, axis=None).to_excel('file.xlsx', index=False)