Get instant live Excel expert help to learn how to use conditional formatting to highlight cells less than or greater than some 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

Hi, I've got 2 columns in Excel. The first has the quantity of an item in stock, the second has the quantity needed for a job. For the second collum, I have conditional formatting so that if the number required is greater than the stock, the cell turns red. And if it is ok (so between 1 & number in stock) then it turns green. Is there a way to copy the conditional formatting to all the other items? At the moment, (using both copy/paste, and the copy formatting brush) it copies the conditional formatting, but references it to the copied item's stock, rather than applying it to the new item's stock.
Solved by X. W. in 17 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
Conditional formatting across a column Y6>=$C$2 Format J6 I've tried relative and absolute referencing to the cells and used format painter to copy down column J but it all formats when it shouldn't, same when using colum referencing rther than cell. So checking if a date cell is greater than or equal to a date in cell C2 and if it is to change the format of cell in column J. Should I be doing this a different way?
Solved by F. Q. in 16 mins
I need a conditional formatting to identify all AVG Rev values in Columns E and F that are 5% greater than the AVG REV in column K
Solved by O. Y. in 13 mins
I am trying to use conditional formatting in my excel sheet. I have used greater than and have it turn green in cell C2 when it is greater than cell B2. I want to apply it to the cells below and have them be greater than the cell next to them but I am not sure how to do that. Every time I do it all the cells still are comparing to B2.
Solved by O. J. in 17 mins
trying to compare if amounts in one column E are greater than amounts in column G, using this formula =E1>G1 with conditional formatting, and not working.
Solved by G. S. in 30 mins
How do i represent in a table, using conditional formatting, 5% greater than another cells predefined value.
Solved by O. H. in 27 mins