SOLVED
Home

Conditional formatting changed from 2010 to latest?

%3CLINGO-SUB%20id%3D%22lingo-sub-741056%22%20slang%3D%22en-US%22%3EConditional%20formatting%20changed%20from%202010%20to%20latest%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-741056%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20got%20a%20rather%20large%20set%20of%20tabs%20using%20Conditional%20formatting%2C%20all%20created%20used%20with%20Excel%202010%20(yes%2C%20I%20know%2C%20it's%20old)...when%20opened%20with%20the%20latest%20version%20(2016%3F)%20some%20of%20the%20formatting%20no%20longer%20works%20properly.%26nbsp%3B%20Is%20this%20a%20known%20issue%3F%26nbsp%3B%20Can%20it%20be%20from%20the%20shear%20number%20of%20formatting%20and%20conditions%3F%3C%2FP%3E%3CP%3EThanks%20for%20any%20help!%26nbsp%3B%20I%20will%20probably%20move%20the%20development%20platform%20for%20next%20year%2C%20but%20I'd%20like%20to%20hold%20off%20this%20year%20in%20spending%20any%20capital%20for%20new%20gear%2C%20updated%20software%2C%20etc.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-741056%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-741072%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20changed%20from%202010%20to%20latest%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-741072%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F372124%22%20target%3D%22_blank%22%3E%40TallTex%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20my%20knowledge%20there%20are%20no%20compatibility%20issues%20with%202010%2C%20only%20with%20earlier%20versions%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FConditional-formatting-compatibility-issues-ef68c97a-1b5e-47eb-9b3f-a548f941df4f%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FConditional-formatting-compatibility-issues-ef68c97a-1b5e-47eb-9b3f-a548f941df4f%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-741074%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20changed%20from%202010%20to%20latest%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-741074%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you!%26nbsp%3B%20I'll%20dig%20deeper%20once%20I%20get%20a%20chance%20to%20spend%20some%20time%20on%20the%20newer%20production%20platform!%3C%2FP%3E%3C%2FLINGO-BODY%3E
TallTex
New Contributor

I've got a rather large set of tabs using Conditional formatting, all created used with Excel 2010 (yes, I know, it's old)...when opened with the latest version (2016?) some of the formatting no longer works properly.  Is this a known issue?  Can it be from the shear number of formatting and conditions?

Thanks for any help!  I will probably move the development platform for next year, but I'd like to hold off this year in spending any capital for new gear, updated software, etc.

2 Replies
Solution

@TallTex 

To my knowledge there are no compatibility issues with 2010, only with earlier versions https://support.office.com/en-us/article/Conditional-formatting-compatibility-issues-ef68c97a-1b5e-4...

@Sergei Baklan Thank you!  I'll dig deeper once I get a chance to spend some time on the newer production platform!

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies