Get instant live Excel expert help to learn how to change background color based on cell value

“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

Trying to apply conditional formatting to a block of cells based on content of one of those cells. I need to highlight w/ one of four colors. The colors are based on criteria within a large list of model numbers that contain letters and numbers. Each color would apply to a portion of those model numbers.
Solved by C. Y. in 20 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 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
I'm looking for a formula that I can set up for conditional formatting to highlight an entire row of cells based on the condition of two specific values. I need this rule to have 8 variant outcomes as well, differentiated by color.
Solved by I. J. in 20 mins
I have conditional formatting on a table column that is based on another column. Is there a way to pull that color into the pivot table without doing an additional conditional format on the pivot table?
Solved by O. D. in 14 mins
I'm looking to change the color of a cell and it's contents to certain colors between certain dates. So in short, I need the cells to be red if the date is between the 1st and 14th, then green if the date is between the 15th and 30th (or 31st). The current formula I am using is the following: RED =TODAY()>DATE(2017,8,1) =TODAY()>DATE(2017,9,1) =TODAY()>DATE(2017,10,1) =TODAY()>DATE(2017,11,1) =TODAY()>DATE(2017,12,1) GREEN =TODAY()>DATE(2017,8,15) =TODAY()>DATE(2017,9,15) =TODAY()>DATE(2017,10,15) =TODAY()>DATE(2017,11,15) =TODAY()>DATE(2017,12,15) So, I went in to the "Conditional Formatting" then went to manage rules, add rule. Then I did it in order of month, red to green. For example I would copy and paste the 8/17 red code and then the 08/17 green code, in order up to December 2017. It is now the 20th and I opened the excel sheet to check if the cell would be green because the date range but it is not. I have an attachable image.
Solved by E. F. in 19 mins
I am trying to use conditional formatting to color the space between two data entries. Here is an example of what I am trying to do, I colored the cells just as an example. This would be a shared spreadsheet where rental home owners would have access to the sheet and would enter in the check in and check out dates for the guest, usually multiple time a month. Any suggestions or ideas ? Thanks
Solved by B. B. in 19 mins
Hello i have this formula in a cell, =IF(I11<>"",IF(H11="",NOW(),H11),"") and i want to conditional format this cell to turn green if its within a a range of time say for instance between the hours of 6:00 am - 8:00 am, and to turn red if it is outside that time frame and no color if it is blank.. I have tried multiple things and i cannot get the excel to recognize the cell as a time instead of a formula, i could not find a time option in conditional formatting.
Solved by C. U. in 24 mins
I am struggling to create a conditional formatting formula that is dependent on the contents of another cell. which changes color depending on the proximity of the contents of the second cell
Solved by I. Y. in 21 mins