 |
To color in an empty cell in Google Sheets, follow these steps:
Step 1: First, you need to select the data you want to color. You can do this by holding down the Ctrl key to select multiple cells. Then, click on the paint bucket icon.
 |
Step 2: The color palette interface will now appear. Click on the color you want to use to color the selected data area. The result will be that the cells have been recolored.
 |
Additionally, you can automatically change the color by pre-formatting the cells as follows (this method will be effective when the cell's value matches the condition you have set):
Step 1: First, click on the area you want to color. Go to the Format section and select Conditional Formatting. Next, choose Formatting Rules and the paint bucket icon to select a color. Once you've finished, click Done.
 |
Step 2: You will obtain a data table similar to the illustration below, with the colors displayed correctly according to the format values.
 |
That was a simple guide on how to color blank cells in Google Sheets. You can apply this to make your documents more lively and easier to understand. Hopefully, this article has taught you another useful feature of Google Sheets.
Source
Comment (0)