Highlight rows based on a cell value

Highlight rows based on a cell value

Hello Sheet users,

We're excited to announce a new feature enhacement, shaped directly by your valuable feedback!

As you might know, conditional formatting is a great tool for anyone dealing with large data sets. Previously, if you’ve ever wanted to draw attention to a single row in your spreadsheet that meets specific criteria, you had to use a formula.

But now?

It's possible with just a click. Whether you want to identify errors, underperforming metrics, blank entries, duplicate values, or match specific text values becomes easier with this new addition.  


How do you do this:
  1. Select the dataset you want to apply the formatting to.

  2. Go to Format > Conditional Formatting.

  3. Select rule type as Classic.

  4. Select the appropriate rule type and enter the value.

  5. Check the Apply to row option.

  6. Select the column where you want to apply this rule. Click Apply.



Some real-world examples where you can apply this feature:

Use case 1:

You’re tracking project tasks in Zoho Sheet, and you want to visually differentiate tasks based on their status (e.g., "Completed," "In Progress," "Overdue"). Rows will be highlighted in specific colours depending on the status.

Use case 2:

You are managing a product inventory spreadsheet, and you want to highlight rows based on the stock level:

  1. Items with stock below 10 are highlighted in red (critical level).

  2. Items with stock between 10 and 20 are highlighted in yellow (low stock).

  3. Items with stock above 20 are highlighted in green (sufficient stock).

Use case 3:

You have run a market research survey and you want to spot invalid responses:

  1. No responses to required questions are highlighted in red

  2. Out of range values indicating invalid responses are highlighted in yellow.

What's next 

We'll extend this feature to support two or more columns in the future update. Currently, you can do it by applying a formula. Visit this help link to learn more.

Try the new way to highlight rows in Zoho Sheet and tell us your feedback. Follow our community to receive all the latest product-related announcements and updates.

 



      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          • Sticky Posts

          • Create and save user-specific filter views with Zoho Sheet

            The filters in Zoho Sheet have become even more collaboration-friendly. Previously, whenever you filtered any data, the filtered view will be updated for all the spreadsheet collaborators. This disturbed the data for others working on the same file. With this new update, you can apply data filters without altering the view for other collaborators in the file.   Collaborate with user specific filters   Let us say you are working on a sales report spreadsheet in real time with two remote colleagues. If
          • Meet the latest feature of Zoho Sheet: Lock Cells

            We are happy to announce the release of one of the most awaited features in Zoho Sheet. ​You can now lock the cells that you wish to keep ​secure. Once you are done with editing cells, you can lock them so that they won't be modified anymore. We believe that this feature will be a great addition to our existing set of collaboration features and is intended to improve your collaboration experience. You can access this new feature Lock from Data tab. Apart from being able to lock individual cell ranges,
          • Feature enhancement: Highlight rows based on a cell value

            Hello Sheet users, We're excited to announce a new feature enhacement, shaped directly by your valuable feedback! As you might know, conditional formatting is a great tool for anyone dealing with large data sets. Previously, if you’ve ever wanted to draw
          • Revamped Print in Zoho Sheet—customized for paper

            The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper.   Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.
          • Slicers are now available in Zoho Sheet—filter your data interactively

            At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,

          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ










                                ご検討中の方

                                  • Recent Topics

                                  • Bug in Total Hour Calculation in Regularization for past dates

                                    There is a bug in Zoho People Regularization For example today is the date is 10 if I choose a previous Date like 9 and add the Check in and Check out time The total hours aren't calculated properly, in the example the check in time is 10:40 AM check
                                  • Embedding Zoho Analytics - is the data always 'live' ?

                                    When embedding "live" Zoho Analytics data into a template with the intention of creating a monthly presentation - how are the embedded filters saved ? When a filter is applied to a presentation from a template is it then fixed for sharing or will it always
                                  • Customer/item(s) bought view

                                    Hello In Inventory/Customers/Transactions tab, how do I see what it is the customer actually ordered/bought without having to open each SO? Our customers buy a number of items thoughout the year. I've look at each transactions drop down, and no-where
                                  • Zoho Flow Doesn't Detect Desk Ticket Custom Field Change

                                    I have a Flow that is configured to be triggered when a custom field on a ticket changes. I also have a Schedule in Desk that runs a script that changes the custom field. When I change the custom field manually in the Desk interface, the Flow runs as
                                  • Weekly Tips: Track Email Engagement with Read Receipts in Zoho Mail

                                    While email is a convenient and widely used way to communicate, it doesn't offer the immediate feedback you get from face-to-face conversations or phone calls. When we send an email, there is no way to know for sure if the recipient has acknowledged its
                                  • Reusable Variables

                                    I’d like to know if there’s a way to store variables in Zoho Analytics that I can use in metrics or calculations. For example, I have a Currencies table that stores the value of different currencies over time. I’d like to use the value of the US dollar
                                  • The Invoice Status in Zoho Finance is misleading

                                    We have many overdue invoices, but when we try to filter it by Status Overdue in the Zoho Finance Module it shows it as none This is also creating a problem when I need to Create a Chart or KPI for overdue Invoices If I open the Invoice I can see the
                                  • Zoho CRM's V8 APIs are here!

                                    Hello everyone!!! We hope you are all doing well. Announcing Zoho CRM's V8 APIs! Packed with powerful new features to supercharge your developer experience. Let us take a look at what's new in V8 APIs: Get Related Records Count of a Record API: Ever wondered
                                  • If Problema Formula

                                    Ceil(Datecomp(${Seguimiento de Venta.Fecha de la proxima visita},Now())/1440) Tengo porblema al plantear el If Quiero que si el valor es dega
                                  • Multi-Select lookup field has reached its maximum??

                                    Hi there, I want to create a multi-select lookup field in a module but I can't select the model I want the relationship to be with from the list. From the help page on this I see that you can only create a max of 2 relationships per module? Is that true?
                                  • Customer Portal Zoho Desk | Sort ticket list

                                    Hello, If you view the ticket list inside the desk portal (https://xyc.zohodesk.eu/portal/de/myarea?departmentId=xyz) all tickets are displayed depending on the filters: department "my tickets" / "team tickets" status group/type channel My questions:
                                  • HTML Code + Writer Documents

                                    Hello, I am in the process of writing a couple of documents in Writer. Both document will have 2 versions each. One version being a freebee that perspective clients can download from my website. The other version will be a paid version, and additional
                                  • This mobile number has been marked spam. Please contact support.

                                    Hi Support, Can you tell me why number was marked as spam. I have having difficult to add my number as you keep requesting i must use it. My number is +63....163 Or is Zoho company excluding Philippines from their services?
                                  • Audit Log: Detailed View and Export for Better Tracking

                                    Audit log tracks all the events or actions performed by the users and displays them in a sequential order. By default, all users who have admin access can view the audit log. We have added new features to the audit log that will enhance the user experience
                                  • Display All Admin Roles in Zoho One Admin Panel

                                    Hi Zoho One Team, I hope you're doing well. Currently, in the Zoho One Admin Panel, we can see Org Admins and Service Admins assigned to specific applications. However, admins assigned at the organization level for various Zoho apps (such as Mail, Cliq,
                                  • Enable users to create and edit presentations in your web app using Zoho Office Integrator

                                    Hi users, Did you know that your users can create, edit, and collaborate on presentations from within your web app? With Zoho Office Integrator's embeddable presentation editor, you can easily add these capabilities. Here are the highlights: Create presentations:
                                  • Forced Logouts - Daily and More Frequent

                                    In the last month or so, I've been getting "power logged out" of all of my Zoho apps at least daily, sometimes more frequently. This happens in the same browser session on the same computer, and I need to re-login to each app separately after this happens.
                                  • I can buy a Domine

                                    I need assistance with an issue I'm experiencing. Whenever I attempt to purchase a domain, I receive a message that says, "We ran into some trouble. Please try again later." I would greatly appreciate any help you can provide. Thank you. Please refer
                                  • What's New in Zoho Inventory | January - March 2025

                                    Hello users, We are back with exciting new enhancements in Zoho Inventory to make managing your inventory smoother than ever! Check out the latest features for the first quarter of 2025. Watch out for this space for even more updates. Email Insights for
                                  • Zoho Customer Statements open item and NOT balance brought forward

                                    How do I set my customer statements to open item and NOT just the balance brought forward. I would like the customer to see all the invoices outstanding
                                  • Free Webinar! From click to doorstep delivery | Enhance your ecommerce fulfillment process

                                    Free Webinar! From click to doorstep delivery | Enhance your ecommerce fulfillment process April 24, 2025, 12 p.m. EDT As your business grows into the ecommerce sector, so do the complexities of fulfillment. From managing real-time inventory to handling
                                  • Zoho Books Invoice Enable Payment Gateway with Deluge

                                    I am using this to create an invoice record in zoho books from zoho crm invoices. I want to add the ability to enable online payment gateway for "stripe".  I can not seem to find one article online on how to do this.  Can someone help? invoice = zoho.crm.getRecordById("Invoices",id);
                                  • Issue List Export

                                    When viewing all Tasks, there are options to filter the list and export. With the Issue list, I can filter, but not export the list. Is there somewhere else to go to get an exported list of filtered issues?
                                  • Ask the Experts 19: Live Expert Panel Discussion - Inside Zoho Desk Spring Release 2025

                                    Hello again! Have you ever needed quick insights into key indicators to help manage and streamline specific operations? Have you started using AI to enhance your customer service in Zoho Desk? From configuring simple bots using Guided Conversations to
                                  • Viewing Live data

                                    Where can I see the live data that is sent from the device?
                                  • Calculating Project Margins and Revenue per Hour in Zoho Analytics Using Data from Zoho Projects and Zoho Expense

                                    Hello, I would like to know if it's possible to use Zoho Analytics to calculate taxes and margins for the projects available in Zoho Projects, while also including the expenses recorded in Zoho Expense. I’m looking to build a dashboard that calculates
                                  • How can a Zoho Desk Admin access restricted files?

                                    How can a Zoho Desk Admin access restricted files from Zoho Desk that are not displayed to agents on tickets due to file type restrictions?
                                  • NOW Zoho Creator still cannot bulk download Image or File Upload Field

                                    The filedownloader has been deprecated for 5 years. Until now, we still cannot have a replacement tool. How can we bulk download the file that we uploaded to Zoho Creator. Previously, it was so simple to bulk download all those files. But now failed to
                                  • Having issue adding email account

                                    Hi Sir/Madam, I having an issue adding an email account (user and group). We have two organization but I am getting an error while adding the account in both User and group. Yet the account is not there. See attached.
                                  • UNEXPECTED RESPONSE CODE: 400"

                                    Getting this on all new flows created with a Zoho Campaigns connection
                                  • Suburb Categorisation/value

                                    Hi All, I have a list of suburbs that my company services, they are categorised by value to the business using a letter grade (A,B,C,D). When a lead is created I want the workflow to check the project suburb and then assign the related grade to a new
                                  • Launching AI-backed product recommendations for ecommerce stores

                                    As Zoho Campaigns steps into its 11th year, we're taking our first step towards artificial intelligence as part of our ecommerce module. Your emails—be they regular or automated— are equipped to carry unique and targeted product recommendations based
                                  • Add Custom Text Fields as a component in Dashboards

                                    Hi Team Idea: Adding custom text fields as components in dashboards. This will allow those of us creating the dashboards to better segment the dashboard into sections allowing a better front user experience where we are showing different categories of
                                  • FSM API ERROR Code "OAUTH_SCOPE_MISMATCH"

                                    I am trying to create a contact via the ZOHO FSM API https://fsm.zoho.com/fsm/v1/Contacts I have followed the instructions of the API documentation to Authenticate and Create a contact but I cant figure out what I am doing wrong. Bellow are the steps
                                  • CRM API Search Record for Last Name equals "."

                                    When using the CRM API to look for all contacts with a lastname = "." The API returns an Invalid Query Reponse I have tried (Last_Name:equals:.) (Last_Name:equals:%5C.) (Last_Name:equals:\.) We have a scenario where the Last Name may not be known for
                                  • Layout Rules Based on Task Owner

                                    We are managing our entire workflow on Zoho Projects From Deal to Shipment to Receiving Payment Now there is one thing that I would like to the ability is to Show or Hide different fields based on Task Owner For example for Shipment Tasks I would like
                                  • Zoho Creator Mobile app no Default Workspace

                                    When I use the Zoho Creator mobile app I do not get a default workspace. This is occurring for me and another new user. I believe this is an issue with Zoho One / Zoho Creator. I have tried working with support and it's been over a week of no solution
                                  • Backup and Restore of Projects

                                    Hi Guys, my boss asked me "do we store regulary offline Backups of Zoho Projects" and i could only answer "no way". Is there really no way to backup and restore a project manualy? As Projects is the main Product we decided to use Zoho it could be that
                                  • Canvas for related lists

                                    Hey, we would like to customize our related lists. For us, it would make more sense to present the data from an assigned record vertical instead of horizontal. Can we get a related list Canvas view?
                                  • Zoho CRM Sales Targets for Individual Salespeople

                                    Our organistion has salespeople that are allocated to different regions and have different annual sales targets as a result. I am building an CRM analytics dashboard for the sales team, which will display a target meter for the logged in salesperson.
                                  • Next Page