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).
In Google Sheets, you can quickly fill cells with colors. Let’s see how to do it!
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.
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!
You can utilize the “Conditional formatting” function.
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.
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.
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
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.
Learn how to do this step-by-step in the video below 👇