Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C C++ C# BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS R TYPESCRIPT ANGULAR GIT POSTGRESQL MONGODB ASP AI GO KOTLIN SASS VUE DSA GEN AI SCIPY AWS CYBERSECURITY DATA SCIENCE
     ❯   

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.


×

Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:
sales@w3schools.com

Report Error

If you want to report an error, or if you want to make a suggestion, send us an e-mail:
help@w3schools.com

W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookie and privacy policy.

Copyright 1999-2024 by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3.CSS.