i am looking for excel formula help. i am looking a formulation that will do the following 6 conditions:
if cell A1 =1 and cell B2 is <150 then make fill color in cell B2 red
if cell A1 =2 and cell B2 is <120 then make fill color in cell B2 red
if cell A1 =3 and cell B2 is <90 then make fill color in cell B2 red
if cell A1 =4 and cell B2 is <60 then make fill color in cell B2 red
if cell A1 =5 and cell B2 is <30 then make fill color in cell B2 red
if cell A1 >= 6 then nothing happen to cell B2
Solved by K. S. in 11 mins