First of all: I've been very happy with openpyxl!
But I've encountered a problem: when opening an existing Excel file with 2 conditional formatting rules using the same cells, only the one with highest priority is preserved by openpyxl.
I have attached an Excel file showing this. In each of the sheets, there are two conditional formatting rules:
- If cell in col. G = "nee", the row turns purple
- If cells in cols. H, I, J and K = "ja", the row turns green.