Conditional formatting not working with XLS file format in Excel 2016

Important: This issue is now closed with the fix indicated below. For more information on other recent issues for your application, see Fixes or workarounds for recent Office issues.

Last updated: October 2016


When you save an Excel 2016 file in XLS file format, and then reopen the file in 2016, it will not update all the conditional formatting rules.

Status: Fixed

We have released a fix for this issue in version 1609 (Build 7369.2024) or later. To update Office, go to File > Account > Update Options >Update Now

Have a feature request?

Lightbulb - Idea

We love reading your suggestions on new features and feedback about how you use our products! Share your thoughts on the Excel UserVoice site. We’re listening.

See Also

Fixes or workarounds for recent issues in Excel for PC

Contact us Contact us Contact us
Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!