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 a formula to change a cell to a different color. In the cell I have a date of when a task was completed. But I want to the cell to change to specific colors when that task is, for example, 15 days old or 30 days old from the day the task is completed. It is suppose to serve as a reminder to the person working on the workbook that everything else that goes with that task needs to be done too.
Solved by O. Q. in 12 mins
I have a large spreadsheet with contacts of Real Estate Agents. Each Contact has 3 ROWS of data that need to be MERGED into ONE ROW. I have created open COLUMNS to allow for Data to be MOVED FROM ROWS 2 AND 3 TO ROW ONE so that all information for each Real Estate Agent is on a SINGLE ROW. I have COLOR CODED where CELLS SHOULD MOVE for a reference point. At the completion of the MERGE there will be TWO EMPTY ROWS between EACH Real Estate Agent Contact that will need to be deleted.
Solved by G. J. in 27 mins
Spreadsheet previously modified by Got It Pro. Rows 1 - 11,841 are correct. I've color coded an EXAMPLE of how 3 ROWS for EACH REAL ESTATE CONTACT Need to ALL MERGE INTO ROW 1 of 3. This will require Formulas and Mapping Fields as done before by a PREVIOUS TECH. LOOK at ROWS 11,843 - 11,848 to see the COLOR CODED EXAMPLE. Then MODIFY THE SPREADSHEET and DELETE ALL ROWS THAT are now EMPTY because the ROWS have been CONSOLIDATED FROM 3 TO 1.
Solved by E. E. in 26 mins
Formatting on last page "in room consumption" Color coded columns for each price point with a color guide on the sheet. If it can fit on one page for printing, that would be awesome!
Solved by M. B. in 22 mins
Hello. I have msexcel where there is a status column which automatically changes color when complete as green, inprogress as yellow and so on. My need is when i select one of the column as completed their dependent column status should go as inprogress in yellow color.
Solved by B. B. in 26 mins
I need a formula to calculate cost based on 3 variables. The variables are chosen from a drop-down list on the HP Calculator sheet. On the Ext Plus sheet, you will see a table. The cost is based on the length, the color group, and the number of ounces. I can't get the formula right for the part that puts any color choice from sheet one into a color group on sheet two.
Solved by S. S. in 12 mins
I need a formula that will match the cell color of a name in 'Sheet 1' with the same name in 'Sheet 2'. The data tables in 'Sheet 1' and 'Sheet 2' are different lengths.
Solved by T. L. in 30 mins
I need a formula for standard deviation for everything in red color on the overall rating chart.
Solved by F. J. in 17 mins
-- Change the color of the "PathTable" to vbWhite (use Interior.Color)
Solved by D. H. in 20 mins
I have created an action item task list. Column C has drop down lists which say complete, pending, and in progress with corresponding color coding. The column next to it is the due date and I would like to get that column to change color as you change the progress status on the left simultaneously.
Solved by E. Y. in 21 mins