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

I have created a Gantt chart. I have a category column I have added conditional formatting to, to control the color based on my key. I want the horizontal duration bars in my chart to match the color formatting of the category associated with each task duration, but I can't figure out how to do it. I'm thinking it'll be based on a conditional formatting in excel formula but i'm not finding what I need online.
Solved by M. Q. in 26 mins
i need a formula that calculates a number and then conditional formatting that assigns a color
Solved by B. C. in 22 mins
Part of the data table (B14:H27) has been set up for you. Particularly, C14 links to the initial loan term assumption D9 and cells D14:H14 are set based on the loan term decrement assumption D10; B15 links to the initial annual interest rate assumption B9 and cells B16:B27 are set based on the initial interest increment assumption B10. Please complete the Data Table set up to calculate the monthly payments (as positive numbers) at different interest rates (B15:B27) and loan terms (C14:H14). Note: the data table is designed to be flexible, i.e., it will update automatically for any changes in the loan assumptions A9:D10. Use Conditional Formatting to format C15:H27 such that all the monthly payments that are higher than the maximum allowable monthly payment in N5 are in red color.
Solved by S. L. in 19 mins
I am trying to write the formulas in conditional formatting that reflects a color change at 30, 60, 90 days before an expiration date. EX: If todays date is entered 2/14/18 in a cell, then the formula should reflex that 1/16/18 is 30 days prior to the expiration date of 2/14/18 and color the cell to red; the second formula should reflex that 12/18/17 is 60 days prior to the expiration date of 2/14/18 and color the cell to yellow; the third formula should reflex that 11/13/17 is 90 days prior to the expiration date of 2/14/17 and color change the cell to orange; any date 91+ days would remain white. I can not seem to get my formulas to flow.
Solved by F. W. in 17 mins
I have created a gantt chart in Excel, that highlights the cells with a color, according to the amount of days an activity has. I use a Conditional Formatting (CF) formula on a group of cells (=OG(J$6>=$E7;J$6<$F7) ) for that. If the formula is true, then the cells change color. My problem is, that the calendar includes Saturdays and Sundays (weekends). How can I write a formula in CF that will jump the weekends and count the rest of the days on monday. Fx. An activity starts on a thursday and last 5 days, then it shall highlight T, F, M, T and W. In advance, thanks for the help.
Solved by T. B. in 19 mins
Apply the Light Blue Data Bars conditional formatting in the Gradient Fill section to the selling prices. Create a new conditional format that applies yellow fill (fourth color under Standard Colors) and bold font to values that contain 98% or higher for the Percent of List Price column. Add a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side. Select Landscape orientation and set appropriate margins so that the data will print on one page.
Solved by O. W. in 26 mins
Some cells are formatting with color as stated in conditional formatting. Check cell B138. It should be green
Solved by M. J. in 14 mins
Can I use excel conditional formatting color to turn cells with a formula in it a different color?
Solved by T. J. in 27 mins
How do I break the relationship of groups of radio buttons? I've set it up to change color when a radio button is selected by using conditional formatting from another cell with numbers, but when I add more than two, I can't get it to work because it changes it to 3 which makes all the ones in that column green instead of just the one I select. I tried assigning the new radio buttons to a different cell, but it still keeps count for all the radio buttons. How do I break that relationship or is there another way to go about coloring a cell when a radio button is enabled?
Solved by X. Q. in 29 mins
Create a new conditional formatting rule that displays any Inventory Value for the Food & Health department with a value of $30,000 or more as Red fill color (second column, last row). There will be two qualifying entries. Note, Mac users select the range G2:G78. Then in the New Formatting Rule dialog box, select the style Classic.
Solved by E. D. in 14 mins