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 Single Color Formatting


Single Color Formatting

Single Color is a premade type of conditional formatting in Google Sheets used to apply a customizable formatting option to all the cells that match a condition.

Here is the Single Color part of the conditional format rules menu:

You can access the menu by selecting the Conditional formatting option in the Format menu.


Single Color Options

From the conditional format rules menu you can choose:

  • Which cells the conditional formatting applies to
  • Which format rule is used
  • The formatting style

Apply to range

In the Apply to range field you can enter the cells and ranges that the Single Color applies to.

You can enter cells and ranges separated by a comma , into the field.

You can also click the icon in the right of the field to select data ranges:

This will open a dialog box where you can add ranges by selection:

Format rules

You can choose which rule to apply from the Format cells if... drop down menu. There are many options:

  • Empty or not Empty cells
  • Text Contains or not Contains
  • Text Starts or Ends with
  • Text is Exactly
  • Calendar Dates
  • Greater than
  • Less than
  • Equal to
  • Between or not Between
  • Custom rules

Formatting style

The Single Color formatting lets you customize both the background color and the font of the cells.

See the Format Colors chapter and Format Fonts chapter for detailed guides of how to customize colors and fonts.



Single Color Formatting Example (Text Ends With)

Highlight the Pokemon name values ending with saur with Single Color conditional formatting.

Copy Values

Conditional formatting, step by step:

  1. Select the range of Name values A2:A10

  1. Click on the Conditional Formatting option in the Format menu

The Conditional Formatting menu will appear in the right-hand side of the spreadsheet:

  1. Select the Text ends with option from the Format rules drop-down menu:

  1. Type saur in the input field:

Now, the Name value cells will have a colored background highlighting if the name ends with "saur":


×

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.