Get instant live expert help on I need help with conditional highlighting excel

“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 need to do a conditional format highlighting in Microsoft Excel. G2 to G11 is dollar amounts. I need to highlight them if they are 5% greater than the dollar amount in J1. I tried "=G2>J1+(J1*0.05)" However, it is highlighting cells that are not 5% greater. Please help.
Solved by T. L. in 23 mins
I just got help using conditional formatting to highlight rows of nonmatching data. I would like to sort these highlighted rows so that everything without highlighting is together. But sorting is not working. I also don't know how to attach the file, because with out the associated worksheet the highlighting doesn't show up.
Solved by C. U. in 18 mins
I need help with conditional formatting. Highlighting a cell once the sum of other values reaches a certain point
Solved by K. W. in 11 mins
I am using conditional formatting and the cell is highlighting although it is not greater that the assigned cell
Solved by I. J. in 22 mins
match case, highlighting and addition ty
Solved by D. U. in 23 mins