Get instant live expert help on I need help with vba fill color
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Hello: Fill Color does not work, nor font color??
Solved by O. H. in 12 mins
Cells with identical data automatically color fill rows in the same color.
Solved by X. E. in 11 mins
VBA HELP (I already have done the fill color to yellow I can not figure out the next steps Using VBA, in column D of the worksheet, enter Invalid Part Number for a row that does not have a valid part number (one that begins with a letter). Change the Fill color to yellow. Next, part numbers that are even numbers are ones the firm produces itself, while ones that are odd numbers they purchase from an external source. Again, using VBA, for the valid part numbers display in column D, Ours for the ones we produce and Purchase for the ones we get from external sources.
Solved by B. J. 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
I can't make the the "fill color" option work. It has locked somehow.
Solved by E. J. in 17 mins