Conditional Formatting deleted by excel when saving and reopening file

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional Formatting deleted by excel when saving and reopening file

FAQ

Thread Tools

Display Modes

02-09-2017, 09:20 AM

xor

Windows 10 Conditional Formatting deleted by excel when saving and reopening file

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,103

I can see that you have Office 2016, so you should save the file as Excel workbook (*.xlsx) not as Excel 97-2003 (.xls). The last mentioned file type can't handle conditional formatting in more sheets without naming.

Furthermore there is a minor fault in your formula.

Attached Files

SAMPLE_2.xlsx (77.8 KB, 11 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Saving as image file removes formatting	md61813	PowerPoint	0	03-01-2016 03:23 PM
A text box (active X) control doesn't work on reopening the file	Chris Baker	PowerPoint	1	06-07-2013 05:51 AM
Saving & reopening comparison	MarshallAbrams	Word	0	03-29-2012 06:19 AM
Conditional Formatting Problem Excel 2007	namedujour	Excel	6	08-04-2011 10:52 AM
Conditional formatting of cell, Excel 2003	Scaffold	Excel	2	05-01-2010 08:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:16 AM.