Get instant live expert help on how to highlight everything
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
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 have created an Excel table. There are 149 rows so far. When I highlight everything and select sort and filter to alphabetize it only alphabetizes the first 50 rows. The first 50 rows are alternating blue and white. The rows after 50 are not alternating colors. How can I alphabetize all 149 rows (I'll be adding more)?
Solved by M. E. in 13 mins
Hi,
I have a file that logs incoming checks. I've messed up the formatting by copying and pasting to extend the log or so I believe that's what happened.
When I highlight everything and try to change the format I am unable to do so.
Any idea of how to fix?
Thank you!
Shelby
Solved by A. W. in 14 mins
How to automaticly highlight the "True" ?
Solved by T. H. in 24 mins
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