I have one cell with a green background, and a border. I have tried to remove formatting. I have checked that there are no conditional formatting. I even checked filters (that was the cause last time something strange happened).

How can I remove this formatting? What are the different ways to cause formatting?


enter image description here

1 Answer 1


It was the search/find feature. For some reason a search had been done earlier (much earlier). The found cells were highlighted with a green background and a black border.

Screenshot: enter image description here


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.