Get instant live Excel expert help with conditional formatting

“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 two sheets in a workbook. The first sheet has formulas to determine a set price. The second sheet has a column that uses vlookup to display the price from the formula. I have another column on that same sheet with old prices. I want to use conditional formatting to highlight prices that are different, but it seems to highlight everything based off of the formula, even if the prices are the same. How can I get it to compare the values from the formula?
Solved by A. B. in 21 mins
I have a 1 column excel spreadsheet with over 8,000 rows in the column. Using conditional formatting, I have highlighted about 350 cells that are spread out within the column. I would like to select the cell below every highlighted cell and highlight them also. Any ideas are greatly appreciated! thanks!
Solved by T. Q. in 13 mins
How do I create a new conditional formatting rule tat displays any Inventory Value for the Food and Health department with a value of $30,000 or more as red fill color
Solved by F. S. in 18 mins
Conditional formatting to color cells red for negative numbers isn't working. It doesn't read the number as negative.
Solved by I. D. in 27 mins
I am trying to paint conditional formatting to cells and carry over some custom rules. But is not working
Solved by E. A. in 12 mins
Conditional Formatting Weekedays in Red and highlight yellow the first 10 days of every month tab C4
Solved by D. H. in 18 mins
Conditional formatting with Icon Sets using percentiles. Check my work do you agree the arrows are setup properly on CF6.1, and how do I get 4 arrows to show instead of 3 on the next tab.
Solved by F. H. in 11 mins
I need help with conditional formatting rows excel. Two rows which have same value in a column must be provided same color.
Solved by C. B. in 24 mins
Hi, there is something wrong with my color functions in Excel, I couldn't open all matters about color function, including changing font colors, filling colors and also conditional formatting. Could you please help me to sort it out?
Solved by K. L. in 23 mins
I need a formula to process "if the date in cell B2 is between the dates 10/1/2018-12/31/2018, then cell A2 will populate Q1. Additionally, cell A2 will turn a certain color since the data inside is Q1. The issue that I am having is that I need this formula to encompass all dates within the calendar year and sort them based on quarters. I've tried to find how to do "IF THEN" formulas, nested "IF THEN" formulas, and even conditional formatting, but nothing is able to encompass all the conditions I need.
Solved by S. W. in 27 mins