• Home
    • About
    • Services
      • All Services
      • Google Spreadsheet Automation
      • Google Docs
      • Google Forms
      • Google Calendar
      • Gmail
      • Google Drive
      • MS Excel Automation with VBA
      • MS Excel Formulas & Template Designing
      • API & Third party Integration
      • Data Visualization
    • Products
      • Sutra Tools
      • Mail Merge Sutra
      • Reconciliation Sutra
    • Contact Us
  • Contact Info

    • Ahmedabad , India
    • ---
    • support@sutraanalytics.com
      • Home
      • About
      • Services
        • All Services
        • Google Spreadsheet Automation
        • Google Docs
        • Google Forms
        • Google Calendar
        • Gmail
        • Google Drive
        • MS Excel Automation with VBA
        • MS Excel Formulas & Template Designing
        • API & Third party Integration
        • Data Visualization
      • Products
        • Sutra Tools
        • Mail Merge Sutra
        • Reconciliation Sutra
      • Contact Us
    Sutra Analytics
    Sutra Analytics
    • Home
    • About
    • Services
      • All Services
      • Google Spreadsheet Automation
      • Google Docs
      • Google Forms
      • Google Calendar
      • Gmail
      • Google Drive
      • MS Excel Automation with VBA
      • MS Excel Formulas & Template Designing
      • API & Third party Integration
      • Data Visualization
    • Products
      • Sutra Tools
      • Mail Merge Sutra
      • Reconciliation Sutra
    • Contact Us

    Cart

    Find And Highlight In Google Sheet

    Sutra Analytics > Blog > Sutra Tools > Find And Highlight In Google Sheet
    • Sutra Tools

    Many times we need to find specific words/values and highlight them with a particular color.
    This can be done by adding conditional formatting too. But wait !! what if you want to highlight many different values in different colors.

    This will require knowledge of conditional formatting & it has to be created multiple times for each use case.

    This tool will help you to highlight the cells which contain the specific word/value/pattern within a selection or in the current sheet.

    CLICK HERE to Install the addon.

    How to Open Functionality:

    • First of all open the Google sheet then go to Extension > Sutra Tools > Find & Highlight as shown below screenshot:
    • It will open the dialog box shown in the below image.

    Use of Functionality:

    • Write the value or regular expression which you want to find in the selection or in the active sheet.
    • You can select the color type by which you want to highlight the matching cells.

    • After that it shows 4 checkboxes:
    1. Clear Existing Formatting: if selected then it clears existing formatting
    2. Ignore Case: if selected then it matches all cases
    3. Match Entire Cell Content: if selected then it matches an exact value in the entire cell
    4. Match Inside Cell: if selected then it finds value inside cell content
    5. Search by Regex: if selected then it highlights values with matching regular expression
    • After that click on the Find button and it will show you how many values have been highlighted in the window.

    Tags: excelgoogle sheet

    Leave a Reply Cancel reply

    Your email address will not be published. Required fields are marked *

    Mail Merge Sutra Contents

    Getting Started Mail Merge Sutra
    FAQ & User Guide Mail Merge Sutra

      Contact Us

      • C-906 Ganesh Glory 11, Nr. BSNL Office, Jagatpur, Ahmedabad, Gujarat 382470
      • +91 79840 99467
      • support@sutraanalytics.com
      • 10:00 AM To 7:00 PM

      Navigation

      • Home
      • About Us
      • Services
      • Portfolio
      • Blog
      • Contact Us

      Copyright 2022 - 2023 - Sutra Analytics PVT LTD., All rights reserved.