google sheets: how can i have conditional formatting with lower priority than manual format? I know how to make the format I want. The document must be in conditional format. However, when I added it. Covered manual formatting. Is there a way to say make this format conditional, unless I say otherwise with some manual format?