Get instant live expert help on how to highlight all

“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 know how to change the values of #N/A to show 100% in a formula, and how to highlight all values 10%or >.
Solved by V. U. in 28 mins
How to automaticly highlight the "True" ?
Solved by T. H. in 24 mins
I want to be able to use conditional formatting to highlight a column of different values in comparison to another column, but all the values vary. I know how to use conditional formatting to highlight a value over or under a set amount but not a varied one?
Solved by E. E. in 18 mins
I need to highlight all cells in red which are 75% above average
Solved by A. W. in 22 mins
I need a formula to compare column G with column H and highlight (say with yellow background) all numbers in column H which are smaller than in column G. How do I do that? :-)
Solved by O. J. in 24 mins