This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
In Excel 2010, I have a column of figures, conditionally formatted to be highlighted when less than the value of a cell in the same row, 8 columns or so over. I then apply an autofilter, and look at only the highlighted cells. However, when I do this on a spreadsheet exported from our ERP via Crystal Reports 11, the autofilter only selects certain, apparently random values. Some are highlighted, some are not. I can instead sort by color, this works, but I would prefer to keep the sheet in its original order. Any ideas on how to make the autofilter work as it should ? The same technique works fine on other sheets, and I can't see why it fails on these. They are not shared, they are saved as .xlsx, and there are no compatibility issues. What should I be looking for ?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Copy the complete sheet to new workbook and then apply autofilter and check what happens.
No change, autofilter still does not correctly select all of the colored cells - conditional formatting appears to be correct, but 'filter by color' doesn't filter by color correctly 100% of the time
Copy the complete sheet to new workbook and then apply autofilter and check what happens.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
The file is saved on my local drive. This wrong behaviour happens even before the file is saved.
CF + autofilter works on this file and others in some circumstances, not others. I'm trying to find the underlying cause of the wrong behaviour, which is not obvious from the data I can see.
I'm not sure what 'status' I' should be verifying ? I can open the file in safe mode, what then should I be looking for ?
Are the other files that work exported from Crystal Reports as well or are they saved locally on your computer?
Open Excel in safe mode and verify the status.
Click on Start> run> type ‘excel /safe’