Tutorials References Exercises Videos Menu
Create Website Get Certified Upgrade

Google Sheets Format Colors


Colors

Colors are specified by selection or by using Hexadecimal (HEX) codes.

Tip: You can learn more about colors and Hexadecimal codes in our HTML/CSS Colors Tutorial.


Theme and Standard Colors

Google Sheets has a set of standard, theme and custom colors available for use. You select a color by clicking on it:

The option with this symbol allows you to select custom colors.


Custom Colors

Google Sheets supports Hexadecimal color codes.

A hexadecimal color code is specified with: #RRGGBB.

RR (red), GG (green) and BB (blue) are hexadecimal values between 00 and FF specifying the intensity of the color.

For example, #0000FF is displayed as blue, because the blue component is set to its highest value (FF) and the others are set to 00.

Tip: Try W3schools.com color picker to find your color!



Applying colors

Colors can be applied to cells, text and borders.

Colors are applied to cells by using the "Fill color" function.

Apply colors to cells step by step:

  1. Select range

  1. Click on Fill color () icon on the Quick Access Toolbar

  1. Select color

The "Fill color" button remembers the color you used the last time.

The Fill color command allows selection of theme colors, standard colors or use of HEX codes by clicking on the option:

Let's try some examples.

Starting with theme and standard colors:

Great!

Try to apply the following colors:

  • Theme color blue to range A3:F3.
  • Theme color green to range A5:F5.

Did you make it?

Let's apply colors using HEX codes.

Apply HEX code #ffcb05 to rangeA7:F7:

Step by step:

  1. Select rangeA7:F7

  1. Open color options

  1. Click on

  1. Insert #ffcb05 in the HEX input field

  1. Hit Enter

Notice that entering the HEX code shows you where the color is positioned on the color map.

Well done! You have successfully applied colors using the standard, theme and HEX codes.