“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

i am looking for formula help. i am looking a formulation that will do the following 6 conditions: if cell B3 =1 and cell K3 is <150 then make fill color in cell K3 red if cell B3 =2 and cell K3 is <120 then make fill color in cell K3 red if cell B3 =3 and cell K3 is <90 then make fill color in cell K3 red if cell B3 =4 and cell K3 is <60 then make fill color in cell K3 red if cell B3 =5 and cell K3 is <30 then make fill color in cell K3 red if cell B3 >= 6 then nothing happen to cell K3

Solved by D. D. in 28 mins

Looking for help, I'm trying to change cell in range bg color in sheet 1 based on sheet 2 cell in range color. For ex. If Sheet 1 A3:F3 = red then Sheet 2 A3:F3 Red.

Solved by Z. E. in 30 mins

need to change the cell color with an If / THEN formula. example: if C3 is less than B3, make the C3 cell RED If C3 is equal to or more than B3 make the C3 cell Green

Solved by V. Q. in 26 mins

I need to pout conditional formatting for a scenario where if the cell value is positive then green and red if the cell value is negative, however, i also need to give refernce to other cell where another value basis which i need to validate before giving the cell a red color

Solved by O. U. in 17 mins