How to Color Cells in Google Sheets

In this article you'll learn ow to color cells in Google Sheets to highlight key numbers, get viewers' attention, or differentiate some cells from others (e.g., ones containing different formulas).

‍

How do I fill a cell with color in Google Sheets?

In Google Sheets, you can quickly fill cells with colors. Let’s see how to do it!

1. Select a cell or a range of cells you want to color.
2. Find and click the “Fill color” icon in the toolbar.
3. Choose the color you want to use in the existing set.

‍

Can’t you find a color you want to apply in the list of the existing colors?

No worries! You can find your favorite color by following the steps below.

1. Click “CUSTOM” or the plus mark beneath “CUSTOM” in the screenshot above, which brings up a pop-up.
2. In the pop-up, adjust the “HUE” to the point you can see the color you are looking for, and then click the point in the picture with a gradation from black (bottom left) to a certain color you picked up in “HUE” (top right).
3. Or, if you are looking for a specific color and you know the color’s Hex color code, you can directly input the color code in the text box at the top of the pop-up.
4. Once you choose a color, click the “OK” button at the bottom of the pop-up.

‍

We recommend that:

(i) you don’t use too many colors in a Sheet;

(ii) you make usage of colored cells consistent in a Google Sheet file;

(iii) you fill in relevant cells with similar colors (e.g., filling a row showing with color and rows below the row showing sub-segments with similar (but lighter) color

Enjoy coloring cells and making your Google Sheets more viewer-friendly!

‍

How do I change the color of a cell in Google Sheets based on the value of another cell?

You can utilize the “Conditional formatting” function. 

1. Select a cell whose color you want to change
2. Go to the “Format” tab and click “Conditional formatting”
3. You can see a pop-up menu on the right side as shown below
4. Choose “Custom formula is” from a pull-down menu named “Format cells if”
5. Input the formula you would like to apply in a box and click “Done”

‍

Here is an example of how to change the color of a cell based on a value of another cell.

Let’s assume we want to change the color of the cell D5 based on a value in cell B5.

1. Determine what conditions you would like to incorporate
2. Let’s assume we want to color the cell D5 in red if it is less than 15 and color it in light green if it is equal to or greater than 15
3. Input 15 in cell D2 as a reference point in a formula
4. In this case, you need to incorporate two formulas shown in the picture

‍

How do I shade in Google Sheets?

You can fill cells, rows, or columns with light gray color as you have learned on this page.

However, if you want to shade every other row by alternating two colors (e.g., white and light gray), there is a better way to go - “Alternating colors” function.

1. Select a range you want to apply a pattern.
2. Go to the “Format” tab and click “Alternating colors”.
3. You can see a pop-up on the right side.
4. You can pick up a pattern you like out of default patterns, or customize your own design.
5. You can also determine if you apply the chosen pattern to “Header” and “Footer”.

‍

Other formulas and tips related to cell formatting

If you don’t get the correct answer to your question in this article or have other questions related to cell formatting, you may find the answers in the following articles.

‍

How to Round Numbers in Google Sheets - round numbers with formulas

How to Show Gridlines in Google Sheets - show/delete gridlines

How to Add Borders in Google Sheets - add various types of cell borders

How to Merge Cells in Google Sheets - combine cells

‍

You can learn about other Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides

‍

Analyze your live financial data in a snap

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows and update numbers in real-time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.