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

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