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 acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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