Besides being the CEO of Winkelwagen, I’m active in one or the other association. For one of them I created a LibreOffice document to fiddle myself through the german tax system for associations which are NOT tax exempt(!).
Today I optimised once again the spreadsheet. One of the things I do is protecting all the formulas so I don’t accidentally change or delete them. Having formular showing on the wrong cell, because I moved stuff around is horrible, hard to find and no fun in context of filing taxes.
The problem I had today is, that when I activated Sheet protection, my conditional formatting was removed, which hihglights the four quarter of the year based on the date. Only the protected cells were shown.
A moment before I activated “View Highlighting” to see which cells are protected, and that was the problem. Either I’m seeing protected cells OR formatting.
Hope it helps you, because I couldn’t find that quick info on the net 🙂