How to Change Color in Google Sheets App
Yes! You can change color in Google Sheets and color-code your document. A colored document always looks more attractive than a bland one. But it is not just about making your google sheets look attractive. It is about giving specific meaning and a strong message. One that cannot be neglected and clearly visible. When you use a shared Google Sheet, using colors increases efficiency. Before delving into the nitty-gritty of how color schemes can be used, let's understand how you can change color.
How to Color Code in Google Sheets
Change Color in Google Sheets: 4 Steps
Step-1 Open the Google Sheets App: To change the color of any cell in Google Sheets, firstly you need to access the application. The application has a green paper icon folded from the top-right corner. It even has a white outlined square on top of it.
- If you do not find it on your phone, you need to download it.
- Go to the play store application and search Google Sheets from the search bar.
- Look for the described icon and install it.
- Let it download and finally open it.
Step-2 Tap on Any Cell: On opening the Google Sheets application, you will see a list of documents that are shared with you or created by you. Click on the document for which you want to change color.
- After opening the document, select the cell you want to color-code.
- If you have not decided how you will use the colored cells, select any cell to practice.
- On reading further you will get an idea regarding how to use colored cells in Google Sheets.
Step-3 Look for the Color-Bucket Icon: By clicking on any cell, a formatting toolbar pops up at the bottom of the page. The first bar is to add text or formula and the second one is for formatting.
- In the second one, there will be an icon shaped like a bucket.
- It looks like a tilted bucket that is spilling something.
- A tiny drop is there at the bottom to signify color dropping from the bucket.
- That is your icon to go to change color in Google Sheets.
Step-4 Select the Color: Once you find the icon, don't wait for anything. Just tap on that and an array of colors will be in front of you. The default cell color is white.
- On the top, you will see only 11 basic colors.
- But, by tapping on each color, its shades are visible below it.
- So, you have 8 shades for each color ranging from darkest to lightest.
Now you know how to change the color in Google Sheets. But let us understand its use. For instance, you have a Google Attendance Sheet. Attendance has three main aspects, present, absent, or on leave. Now, you want a quick glance at a particular person's attendance status. For that, you would have to read every cell and make out.
- Instead, you can set green color for Present, red color for absent, and yellow or orange for on leave.
- Now you can just open your attendance sheet and in a glance, you can make out who has remained more absent and present.
- Similarly, you can do this for progress reports or task sheets.
- You can select different colors for work assigned, work pending, work approved, or work rejected. Like this, you will always stay clear about the status of anything.
So, start color-coding your Google Sheets today and see the increase in efficiency it brings.