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

Hi I need to do a SUMIFS function with horizontal and Vertical. Yellow color highlighted area's in the attached excel sheet has to be the criteria;s which varies. These should pick from the data sheet
Solved by D. W. in 23 mins
Task Please combine both data sets into one tab, bring ‘multi color’s and ‘Goal Completions All’ to the Data Source 1 and add a pivot table to map keywords to URLs. Values for each URL should be: Count of ‘keywords’
Solved by A. Y. in 26 mins
I am trying to do a 12month rollover chart that shows 100% per month with one color (total orders) and (percentage on time) with a different color. I am getting some errors and the chart does not look accurate.
Solved by X. U. in 20 mins
I am struggling to create an excel conditional formatting formula based on another cell. which changes color depending on the proximity of the contents of the second cell
Solved by I. Y. in 21 mins
VBA to set Forecolor of ListBox listItem doesn't work. No Run time error, it just doesn't change the color
Solved by I. J. in 29 mins
whenever column K has a non-zero value, I would like 7% of that calculated in corresponding cell of column P, also can you help color code column K with different colors dynamically for 10, 20, 30, 40 50
Solved by M. A. in 27 mins
Hi there, I am taking your time to ask you a question about select a series of data with the cell format. I had two lists of data and I did find duplicate values in 2 lists and the duplicate values' background is different from the unique ones now. Now I would like to select all unique values in Column A. Is there any quick way to do that. I did try sort by color, but because it has formula, it messes up the values.
Solved by V. Y. in 28 mins
You rep was working on VBA file unable to complete it in time. Rep sd to contact again and one of your colleagues will share to color the cell on two consecutive visit
Solved by S. E. in 20 mins
Is there a way to have a cell in excel change color based on the amount of information added? So, after 3 dates are added to a cell I would want it to change to green, 4 would be yellow, and 5 would be red? Can you help me with excel change cell color based on value?
Solved by K. D. in 11 mins
I have two workbooks. One (which I've uploaded) named "Master" and another named "Update". They are the same in regards to structure and format. Only some of the data is different. In both workbooks, Column A contains model numbers. Columns K & L contain corresponding prices for those model numbers. The same exists for column N (model numbers) and Columns X & Y (prices). In both workbooks all prices are either (font color) black, red or blue. My task is to compare the two workbooks looking for model numbers in the "update" workbook which are also found in "Master". (columns A & N in both workbooks) When a duplicate model number is detected, using the "Master" model number, check the price in column K. If it is black, do nothing. If it is red or blue, copy it and paste it on the "update" workbook in column K in the row of the corresponding model number. Then, do the same for the price in column L. The same process would be applied to the model numbers in column N and the corresponding prices in columns X & Y. So, the end result would be... From the Master workbook any prices which are Red or Blue would be inserted into the correct location in the Update workbook. Any Black prices in the Master workbook are left alone.
Solved by C. D. in 15 mins