Topview Logo
  • Create viral videos with
    GPT-4o + Ads library
    Use GPT-4o to edit video empowered by Youtube & Tiktok & Facebook ads library. Turns your links or media assets into viral videos in one click.
    Try it free
    gpt video

    Conditional Formatting with Color Scale using Google Sheets

    blog thumbnail

    Conditional Formatting with Color Scale using Google Sheets

    Greetings and welcome to this instructional article where we will delve into the topic of conditional formatting with color scale using Google Sheets. The aim is to enhance the visual appeal of your data by applying formatting based on specific conditions. In this tutorial, we will focus on creating a color scale to indicate the range of values in a column from lowest to highest.

    To begin, select the column you wish to format, typically by clicking and dragging from the top cell to the bottom cell. In this example, we will use cells C2 to C62. Next, navigate to the "Format" menu and choose "Conditional formatting." This action will open a sidebar where you can set the parameters for the color scale.

    By default, Google Sheets provides a green color scale that transitions from dark to light. However, you have the flexibility to customize the colors as per your preference. For our demonstration, let's opt for a range from green to red, where shorter distances are represented in green and longer distances in red. You also have the option to create a custom color palette and adjust the minimum, midpoint, and maximum values individually.

    Once you have configured the color scale to your liking, click "Done" to apply the formatting. If you found this article helpful, consider liking and subscribing for more content.


    Google Sheets, Conditional Formatting, Color Scale, Data Visualization, Customization, Visual Interest


    1. How do I apply conditional formatting in Google Sheets?
    2. Can I customize the color scale for conditional formatting?
    3. What are the benefits of using color scale for data visualization in Google Sheets?

    One more thing

    In addition to the incredible tools mentioned above, for those looking to elevate their video creation process even further, stands out as a revolutionary online AI video editor. provides two powerful tools to help you make ads video in one click.

    Materials to Video: you can upload your raw footage or pictures, will edit video based on media you uploaded for you.

    Link to Video: you can paste an E-Commerce product link, will generate a video for you.

    You may also like