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 to conditionally format some cells the color of Red based another cell, project type, setting while other cells requiring no entry should be formatted to Gray. The columns indicating 'yes' need to be formatted to Red; the columns that are blank need to be formatted as Gray.
Solved by M. B. in 13 mins
I need to fill columns B through J with either Red or Gray based on the value entered in Column A. Lines 11 through 14 on the spreadsheet have the logic for the color format. I got disconnected...
Solved by A. D. in 11 mins
I need help inexcel conditional formatting based on another cell color. In the file, the cell will not show based on there not being text in the 'Student Column", but the cell color coded with a uniform color if no data appears.
Solved by O. F. in 27 mins
I need to know the formula as to average the individual GREEN, RED, and BLUE cell data together in the TOTAL GREEN, RED, and BLUE cell at the bottom that have data in the cells. So, if there is no data in the individual cells the AVERAGE formula ignores these cells, and only averages the ones with numbers. There is not a specific 'range' for this, but the individual cells for each color that needs to be AVERAGED.
Solved by O. B. in 23 mins
Color changing charts based off of weight goals for the day and week. every week the goal weight will change. also how to use pivot tables and graphs that update automatically from that. etc.
Solved by T. F. in 23 mins
I would like to know if I can change the default sort in Excel 2016. I have many sheets to sort and each time I need to go to Data>Sort then change Sort by from the current default Formula no to Product name. Then change Sort on from Values to Font color & then change order to Red color & then change to On Bottom. Is there any way to set the default sort with these parameters so I dont need to do this every time?
Solved by O. Y. in 13 mins
I cannot figure this step out and need help please. Step 1: At this point, a smaller list of countries should be visible in the worksheet “Internet user and pop. Table”. Cross reference these countries with the list of tech ready countries in the “Tech Readiness 2016” and highlight in the “Internet user and pop. Table” worksheet the country or countries that are in both lists. You may choose any shade of orange as the highlighting color. Cross reference them using conditional formatting.
Solved by K. D. in 20 mins
I have used the countonbgcolor script to count the background color as: function countOnBGColor(range, colorref) { var sheet = SpreadsheetApp.getActiveSheet(); var color = sheet.getRange(colorref) .getBackground(); var range = sheet.getRange(range); var rangeVal = range.getValues(); var count = 0; var allColors = range.getBackgrounds(); for (var i = 0; i < allColors.length; i++) { for (var j = 0; j < allColors[0].length; j++) { if (allColors[i][j] == color) count += 1; }; }; return count; } This works great but it does not update when the the sheet is updated. Is there a way to get the script to function automatically to update the value in change with the background color, even reloading the page doesn't update it. The only way I can get it to update is to change it then change it back. PFA Link.
Solved by K. L. in 29 mins
I have a spreadsheet that I have to print daily schedules from I have it conditional formatted so when I enter an X in the first cell of the row the row highlights. Through out that row there are X's in the cells of the daily sheet I must print from tabs at the bottom of the spreadsheet. So I have two questions: Is there a formula that I can write so when I enter that X in the first cell it makes any other cell with an X in it print the corresponding bottom tabs daily schedule sheet. So looking at this I want the first X to say print sheet 3,8,12,15 from the tabs below. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 x x x x x tabs at bottom 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Or this would be my other option: Conditional formatting. My other question is on this same spreadsheet, Is there a formula that I can write so that when I enter that same X in that first cell I have conditional formatting that will highlight the X's in that row a color of my choice. I am thinking some kind of IF / THEN statement.
Solved by A. A. in 17 mins
I'm trying to use conditional formatting to color code cells that are greater or less than another cell. However there is text in the cells and the conditional formatting isn't correctly color coding values that are higher or lower.
Solved by Z. F. in 28 mins