I have cells that contain different background colors.
I want to use conditional formatting in order to highligh certain rows e.g. via change of borders or foreground color.
If I set a new format, it always overwrites the existing background color.
Is there a way to only change a specific aspect of the current format via conditional formatting?