Vietnam.vn - Nền tảng quảng bá Việt Nam

Instructions for coloring blank cells in Google Sheets extremely simple

Báo Quốc TếBáo Quốc Tế18/11/2023

In Google Sheets, there are many ways to color blank cells or cells with text in Sheets. This article will guide you how to color blank cells in Google Sheets very simply with just a few operations on the computer that anyone can easily do.
Hướng dẫn tô màu ô trống trong Google Sheets cực đơn giản

To color a blank cell in Google Sheets, follow these steps:

Step 1: First, you need to select the data area that you want to color. You can do this by holding down the Ctrl key to select multiple cells. Then, select the paint bucket icon.

Hướng dẫn tô màu ô trống trong Google Sheets cực đơn giản

Step 2: At this time, the screen will display the color palette interface, you click on the color you want to color the selected data area. The result is that the cells have changed color.

Hướng dẫn tô màu ô trống trong Google Sheets cực đơn giản

Additionally, you can also change the color automatically by formatting the cells as follows (this will work when the cell's value matches the condition you set):

Step 1: First, you click on the area you want to color. Go to Format and select Conditional Formatting. Next, you select Formatting Rules and the paint bucket icon to choose a color. Once complete, click Done.

Hướng dẫn tô màu ô trống trong Google Sheets cực đơn giản

Step 2: You will get a data table like the illustration below, the colors are displayed correctly with the formatted values.

Hướng dẫn tô màu ô trống trong Google Sheets cực đơn giản

Above is a very simple guide on how to color blank cells in Google Sheets, you can apply it to help your documents become more vivid and easier to understand. Hopefully through this article you have learned another useful feature of Google Sheets.



Source

Comment (0)

No data
No data

Same tag

Same category

Image of dark clouds 'about to collapse' in Hanoi
The rain poured down, the streets turned into rivers, Hanoi people brought boats to the streets
Re-enactment of the Ly Dynasty's Mid-Autumn Festival at Thang Long Imperial Citadel
Western tourists enjoy buying Mid-Autumn Festival toys on Hang Ma Street to give to their children and grandchildren.

Same author

Heritage

Figure

Enterprise

No videos available

News

Political System

Destination

Product