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:
You can simply click and hold and drag your cursor over the cells you wish to highlight.
The Fill color icon looks like a bucket pouring paint.
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:
Screencap:
You can simply click-hold and drag your cursor over range of cells to highlight.
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.
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:
Screencap:
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:
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.
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:
Once you set the color, click OK.
The range may include cells without highlights.
For this example, we will click Fill color.
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:
We hope this article has helped you and given you a better understanding of how to highlight in Google Sheets. You might also like our articles on how to wrap text in Google Sheets and how to indent in Google Sheets.
To optimize your workflow, we recommend reading our guide on how to create an email list and trying our software for managing due dates!
-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
Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.
.png)
