Get instant live Excel expert help to learn how to highlight a cell in 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'm having a problem with cell AH237 on the "Design CTR". It is meant to show an average % for all tasks which have started in accordance to the start date; however if highlight the cells within row AH between cells 137:236 for only the cells greater than 0 it gives you a result of 93%. This value is what I would expect to see in AH237 but it's showing 100%. The formula seems to work in the sections above, i.e. cells AH113 or AH91 or AH69
Solved by F. J. in 26 mins
I am trying to highlight row based on cell value on its ratio in excel.
Solved by X. S. in 11 mins
trying to generate a weekly spreadsheet/ report to send out as a refresher on leads...need to highlight the lead status , stage, leads not converted & converted
Solved by A. B. in 11 mins
i am trying to do a conditional formatting excel where if one column doesn't follow the < or > in another column to the value in the third column it will highlight it
Solved by D. D. in 26 mins
hey! I am attempting to highlight action items on this list and automatically have them sent to another list with only the highlighted items.
Solved by I. Y. in 11 mins
Hi, I need help on excel highlight blank cells. The purpose is to highlight an entire row if a specific cell (specifically, one in column L) is blank.
Solved by O. B. in 22 mins
Can you add more cells down to highlight before reaching another date, then paste it?
Solved by Z. J. in 23 mins
I would like to be able to check a box and have it highlight a certain cell. So lets say in my attached sheet if I check the box in F4 I want A4 to highlight yellow, A4 contains a drop down list so not sure if that matters, and if I check E4 I want it to highlight A4 blue. Is this possible?
Solved by Z. C. in 28 mins
Hi, can we highlight A column row where the B column shows a match ?
Solved by X. H. in 16 mins
Hi there im just wondering if it would be possible to create a conditional formatting that allows you to click on a point in a scatter plot and have it highlight a row/cell of data?
Solved by A. H. in 17 mins