Marcelo Branco
MrExcel MVP
- Joined
- Aug 23, 2010
- Messages
- 17,103
- Office Version
- 2021
- 2010
- Platform
- Windows
Hi,
On a previous post i received from two MrExcel MVP formulas for Conditional Formatting. The two formulas worked perfectly, but when i Save/Close/Re-opened the file the CF is lost.
I made a search in the internet and found:
http://thedailyreviewer.com/office/view/conditional-formatting---losing-values-112929782
http://thedailyreviewer.com/office/view/losing-conditional-formatting-when-saving-112440848
http://thedailyreviewer.com/office/view/losing-conditional-formatting-112962815
but no practical solution.
After many attempts, at last i found out a workaround saving the file in binary format (.xlsb) that keeps the CF intact after Save/Close/Re-open.
Is that normal? Cant i save the file on standard format (.xlsx)?
Tks in advance
M.
On a previous post i received from two MrExcel MVP formulas for Conditional Formatting. The two formulas worked perfectly, but when i Save/Close/Re-opened the file the CF is lost.
I made a search in the internet and found:
http://thedailyreviewer.com/office/view/conditional-formatting---losing-values-112929782
http://thedailyreviewer.com/office/view/losing-conditional-formatting-when-saving-112440848
http://thedailyreviewer.com/office/view/losing-conditional-formatting-112962815
but no practical solution.
After many attempts, at last i found out a workaround saving the file in binary format (.xlsb) that keeps the CF intact after Save/Close/Re-open.
Is that normal? Cant i save the file on standard format (.xlsx)?
Tks in advance
M.
Last edited: