@milan had to fight with something like this some time ago. Solution? No. I don‘t understand conditional formating in LibreOffice at all.
Ok. Sometimes it works. But often it does not.
The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!