How do I change the default color for anything which I type into Google Sheets?

When it's a URL it seems to go to one color, when not, another. I'm not looking to delve into JavaScript. I just want everything typed or pasted in, any text at all, to be a specific color. Going back to change the font is awkward.

I want unconditional, or every condition, formatting. This is not a JavaScript question, nor is it how to set up conditional formatting.


This isn't 100% automatic, but the Table Styles Chrome plugin says it can apply formatting with one click. Does that help at all?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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