Get instant live Excel expert help to learn how to apply conditional formatting based on another 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
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
Suppose you are consultant for a farmer who owns 100 acres of usable land. She wants to plant some combination of corn and wheat on the land. She wants you to build a spreadsheet that will calculate NPV and IRR based on her estimates for costs and revenues related to this project. Create an NPV analysis template that the farmer can use to make the optimal investment decision. Use the following template. Excel HW #4 - template.xlsxPreview the document "Assumptions" Tab Insert placeholder data of your choosing into yellow input cells Create dynamic calculations for all non-input cells "Worksheet" tab Create dynamic calculations using data from assumptions tab "ROI" Tab Create dynamic cash flow calculations for each year using data from the other tabs Use excel formulas to calculate NPV and IRR based on the net cash flow data Use conditional formatting to indicate when the NPV and IRR indicate a good investment "Scenarios" Tab Answer the questions relating to each scenario using your completed spreadsheet as the calculator Seek help from classmates and/or TAs as necessary. Upload your completed file to Canvas prior to the due date
Solved by B. B. in 28 mins
Hello. I'm looking for a conditional formatting formula to highlight a range of cells based on value of another cell range. I'm using Google Sheets.
Solved by S. H. in 23 mins
I want to take a numerical value in cell C32, then, based on both the start date in cell D32 and the term of the contract in cell (E32), populate the value in cell C32 over the next (36) months in cells F32..AO32. The "key" is to have the conditional formatting start the population of cells in the correct cell (month)
Solved by M. E. in 15 mins
I am trying to use a simple Conditional formatting to highlight the row based on the data in column B. My formula is copied from several other online sources. I am actually using the same formula in another workbook, and its fine. I don't understand why this isn't working. =\$B2="NA" is the formula. Chose a color for highlighting. Selection of my entire sheet - Nothing. It doesn't highlight. I have moved the formula and changed the data. Lost and Confused. please help.
Solved by D. B. in 14 mins
I need to use conditional formatting to highlight data in a range based on the date. Example: From July 8th to July 14th, I need the data in range d4:s4 to be filled blue. But once that date passes to not longer be formatted.
Solved by D. Y. in 29 mins
Conditional Formatting Question: I want to highlight the top cell (title cell) of a column based on the information in that column. I.e. if there are empty cells in column C, the title of the column (C2) is highlighted red.
Solved by T. F. in 19 mins
I have data in two columns A and B. I have 9 conditions based on those two columns.Like if A<0, B<0 I want it in green colour, if A<0, B>0 in another colour, if A<0, B=0 in another colour, if A>0, B<0 in another colour, if A>0, B>0 in another colour, if A>0, B=0 in another colour, if A=0, B<0 in another colour, if A=0, B>0 in another colour, if A=0, B=0 in another colour,. How can i achieve it by conditional formatting
Solved by K. A. in 18 mins
Use conditional formatting to identify all AvgRev values where the AvgRev is more than 5% greater than the AvgRev FOR THAT CARCLASS calculated in Item 17 above. DO NOT USE the calculated AvgRev number, instead USE the cell contents of the AvgRev value so that if either Revenue or NumCars change in a particular row that the conditional formatting is based on the updated value for Average Quarterly Revenue
Solved by A. F. in 28 mins