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

how to use in excel after one cell color

Solved by K. J. in 17 mins

Help me to color excel row by value of a cell

Solved by B. B. in 15 mins

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

Can we make pivot tables based on cell background color (Pivot table calculations by cell color)?

Solved by G. U. in 28 mins

i am new at excel want to understand countif function

Solved by Z. H. in 16 mins