How can I have conditional formatting with lower priority than manual formatting

Question

I know how to do the formatting that I want. The document should have conditional formatting. However When I added it. It covered the manual formatting.

It there a way to say do this conditional formatting, unless I say otherwise with some manual formatting?

Answer 1

Step 1 Create an extra column called ManualFormat and fill it with checkboxes.

Step 2 Add to your conditional formatting a condition that the checkbox must be false

Not the most elegant solution but you can't easily see if something is already formatted from the conditional format feature.