In this article we will show you how to highlight in Google Sheets. We cover how to highlight text and cells. Simply follow the steps below:
How to Highlight Cells in Google Sheets
1. Select the cells to highlight
You can simply click and hold and drag your cursor over the cells you wish to highlight.
2. Click the Fill color icon in the main toolbar
The Fill color icon looks like a bucket pouring paint.
3. Select the fill color
A palette will appear, containing standard colors with an option for custom colors, conditional formatting, and alternating colors.
The highlight will automatically be applied once you select the color from the palette:
How to Highlight Text with Color in Google Sheets
1. Select the cells with text to highlight
You can simply click-hold and drag your cursor over range of cells to highlight.
2. Click the Text color icon in the main toolbar
The icon is a capital letter A with a bar of text color below, set as black by default. Notice that the bar below also changes color when you change text color.
3. Select the text color
A palette will appear, containing standard colors with an option for custom colors and conditional formatting.
The highlight will automatically be applied to the text once you select the color from the palette:
Can I Highlight Using Both Fill Color and Text Color in Google Sheets?
Yes! Additionally, you can choose which of the two to do first: fill color or text color. Afterwards you can even apply boldface style to text to emphasize the value more:
How to Highlight Non Adjacent Cells in Google Sheets?
There is a slight adjustment to the process but it essentially remains the same. Hold the Ctrl (CMD on mac) button while selecting cells.
Afterwards do the steps 2 and 3 as outlined in the previous sections.
How to Select Custom Color for the Highlight in Google Sheets?
In the step where you select the color from the palette, click the icon of a circle with plus sign.
This option is present in both fill color and text color palettes, but we will only have the fill color as an example.
You have two ways of specifying the custom color:
- Specifying the hex code for the color
- Adjusting the hue slider and the color map to select the desired color
Once you set the color, click OK.
How to Remove Highlights in Google Sheets?
1. Select the cells with highlights
The range may include cells without highlights.
2. Click the Fill color icon or Text color icon, whichever you want to remove
For this example, we will click Fill color.
3. Click Reset
The Reset option is at the top of the drop-down color palette that will be loaded after clicking either the Fill color or the Text color icon.
The highlight has been removed:
-Highlight Duplicates in Google Sheets
-Highlight Row Based on Cell in Google Sheets
-Conditional Formatting in Google Sheets
-How to Strikethrough in Google Sheets
-How to Remove Gridlines in Google Sheets
-How to Underline in Google Sheets
-How to Hyperlink in Google Sheets
-How to Add Bullet Points in Google Sheets
-How to Indent in Google Sheets