Conditional formatting in openpyxl applies Excel's native formatting rules — the logic runs in Excel, not in Python. Python only writes the rule specification. - The `ColorScaleRule` `start_value`, `mid_value`, `end_value` with `type="percentile"` sets the color scale relative to the data range, so