Conditional formatting not working with XLS file format in Excel 2016

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

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!