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?


1 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.

  • A good idea, but it will not work for me, as I would have to train my collaborators to tick the box. +1 but no tick. Commented Apr 26, 2020 at 21:37
  • @ctrl-alt-delor Why is someone highlighting data? Often I find the reason why people are highlighting something is because they do not have a checkbox to indicate something, perhaps their manual formatting itself could be a checkbox. So if they are simply highlighting an entire row yellow then you can make a checkbox column called highlight entire row. Maybe you should post example data of how you are highlighting and why they are highlighting in conflict of your formatting.
    – CodeCamper
    Commented Apr 27, 2020 at 13:03
  • Same reason they make heading by changing font size. It is not the right time to educate them. Commented Apr 27, 2020 at 18:50
  • @ctrl-alt-delor can you put in your question or here a small sample of your conflicting conditional formatting.
    – CodeCamper
    Commented Apr 27, 2020 at 21:34
  • @ctrl-alt-delor I want to play with a small sample of what you are experiencing so I can try out a few different solutions.
    – CodeCamper
    Commented Apr 27, 2020 at 21:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.