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 Conditional Formatting


Conditional Formatting

Conditional formatting is used to change the appearance of cells in a range based on your specified conditions.

The conditions are rules based on specified numerical values, matching text and more.

Changing the appearance of cells can visually highlight interesting data points for analysis.

Google Sheet provides a number of preset formatting options, as well as customizable format options and conditions.

The two main Conditional Formatting options are:

Single Color formatting applies a single customizable formatting option to all the cells that match a condition.

Color Scale formatting applies a background color that smoothly changes between 2 or 3 colors based on the values of cells in a range.

Note: Single Color formatting lets you customize both the background color and the font in the cells.


Conditional Formatting Example

Here, the Speed values of each pokemon is formatted with a Color Scale:

Note: Google Sheets can customize the color and behaviour of color scale conditional formatting.


Clear Formatting

Conditional Formatting can be removed by selecting the range of cells you want to remove the conditional formatting from and selecting the Clear formatting option from the Format menu:

Note: You can read more about removing formatting in the Clear Format chapter.

Rules can also be removed in the right-hand side Conditional format rules menu.



Manage Formatting

Conditional Formatting can be managed in the right-hand menu.

The menu is accessed by selecting the range of cells that already have conditional format rules and selecting Conditional format from the Format menu.

From this menu you can add extra rules:

You can remove rules by clicking the recycling bin icon:

Click the four vertical dots on the left of a rule and drag up or down to rearrange the rules:

Note: The rule at the top of the list is the one that will be applied.


×

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.