how to change color in google sheets

How to Change Cell Color in Google Sheets

By David Martin
AD

Transforming the look of your spreadsheets has never been easier, thanks to Google Sheets' versatile customization options. One of the most striking changes you can make is altering the color scheme. Let's delve into how you can change the color in Google Sheets for both your cell backgrounds and text, enhancing both your document's aesthetic appeal and functionality.

Before we dive into the specifics, ensure you're working on a Google Sheets document. If you're not already, simply create a new one by visiting Google Drive, clicking on the "+ New" icon, and selecting "Google Sheets".

Changing Cell Background Color

Assigning a background color to your cells is an excellent way to categorize data or draw attention to specific rows or columns. Google Sheets offers a rich color palette to choose from.

AD
How to Change Your Google Sheets Theme Color
How to Change Your Google Sheets Theme Color
How to get the HTML color codes in Google Sheets - Plus every color in the color picker!
How to get the HTML color codes in Google Sheets - Plus every color in the color picker!
Count the Colors in Google Sheets - Teacher Tech with Alice Keeler
Count the Colors in Google Sheets - Teacher Tech with Alice Keeler

Here's how you can change your cell background color:

Using the Ribbon

Google Sheets' toolbars make color changes straightforward. First, select the cells you want to modify. Next, click on the "Fill color" icon in the toolbar, positioned between the 'Text' and 'Bold' icons. You'll find a color palette; click on the color you'd like.

📊 Color Coded Dropdowns in Google Sheets
📊 Color Coded Dropdowns in Google Sheets
Google Sheets: Change Graph Colors
Google Sheets: Change Graph Colors

For more intricate colors, click on the "+" icon at the bottom of the palette. This reveals the color picker, allowing you to create custom colors or select from a spectrum of shades.

Using the Format Menu

If you prefer a menu-driven approach, follow these steps: Select the cells you want to color, then click on "Format" in the menu bar, and select "Conditional formatting". A side panel will appear. Under 'Format cells if...', choose 'Custom formula is'. Type an appropriate formula, click on the format style (in this case, 'filled background color'), and select the color you want.

AD

Among the available options, you'll find a wide range of colors, gradients, and even image fill options to give your spreadsheets a unique touch.

Changing Cell Text Color

While changing the background is one way to highlight your data, altering the text color can provide further emphasis.

Here's how to change your cell text color:

AD

Using the Ribbon

Just like changing the background color, selecting cells and clicking on the "Text color" icon (right next to the "Fill color" icon) will open a color palette. Choose the color you prefer, and your text will automatically switch to that color.

To have both cell background and text in different colors, follow the same 'fill color' steps as above, then change the 'text color' using the same method.

Using the Format Menu

Similar to the 'fill color' steps, you can use conditional formatting to change text color. After selecting the cells and clicking on 'Format' -> 'Conditional formatting', choose 'Custom formula is' under 'Format cells if...', then 'Font color', and finally pick the color you want.

AD

Creating visually engaging spreadsheets with Google Sheets is just a matter of exploring these color customization options. Your data will not only be organized but also captivating to view and work with. Happy color-picking!

AD