Microsoft Office Forums - View Single Post - [Solved] Conditional Formatting deleted by excel when saving and reopening file

Thread: [Solved] Conditional Formatting deleted by excel when saving and reopening file

View Single Post

Old

02-09-2017, 09:20 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

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)

Reply With Quote