Get instant live Excel expert help to learn how to color in excel cell

“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 need all the data present in column 1 of workbook "Paste Menu" in workbook "Run" in these four columns. 1- Name of the dishes which is of font 12 in column 1 of workbook "Paste Menu" move it under "Name" column of workbook "Run" 2- Description of the dish which is of font 10 and grey color to be moved under Description column in Run work book corresponding to each food 3- Price should be moved under price column of Run workbook
Solved by B. L. in 19 mins
I want to conditional format a spreadhseet such that all rows with the same time stamp take on the same color.
Solved by K. E. in 22 mins
I would like to add a column by background color, how do I do that?
Solved by C. C. in 25 mins
Is it possible to sum up numbers based on font color? I would appreciate some kind of sumif formula for that
Solved by F. D. in 22 mins
I need to change the color of entire row based off the value of a single cell, but the value isn't consistent. It's varying dates. I have the formula =$O2="complete" but I want it to be something like =$O2= DATE Is that possible?
Solved by E. L. in 30 mins
i have a spreed sheet with list of prices from different company's. In the header of each column have the company.The first cell of each row gives me the driver and the rest of the row gives me the company prices.The two last columns give me the value of minimum and maximum price for each row. is there a way were i can relate the value in the last two column with company in the header section? for example; the color that i gave to each company be the same in the value in the two last column.
Solved by I. C. in 22 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 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
Hello! Need some work counting and sorting stuff (you'll get a little disoriented I think because some of the text in Excel is written in Romanian, but it should be fairly easy). Here we go! So, in the "note" sheet (yellow color), between the cells D156:I167, I need to count how many 'FB1s/FB2s/FB3s/IE1s/IE2s/SPEs' are (these are groups or 'grupa' as we call them, located in D column), according to their grade (or 'nota', located in the F column). For example, if there are 4 FB2s in Column D with the grade 5 in column F, that number should be located in cell E160, and so on. Also, the columns D and F MUST be volatile.
Solved by E. Q. in 27 mins
i need a formula that color codes a cell based off of its previous cell. doesnt seem too complicated as i can create a video description of exactly what i need..thanks
Solved by D. Q. in 15 mins