 # Get instant live expert help on I need help with excel split cell diagonally fill half color “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

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
I have a problem regarding to Fill a cell with color based on a condition
Solved by F. A. in 26 mins
how do I color code a worksheet such that each color represents a condition where I can manually select the color fill for the cell from a drop down menu showing conditions
Solved by T. F. in 24 mins
Hello: Fill Color does not work, nor font color??
Solved by O. H. in 12 mins