Tip #7: Four things you didn't know you can do with Conditional Formatting

Tip #7: Four things you didn't know you can do with Conditional Formatting

Conditional formatting helps you highlight and visualize data in your spreadsheet based on provided rules. Zoho Sheet offers three types of conditional formatting: Classic, Color Scales, and Icon Sets.


If you're already familiar with how Conditional Formatting works, here are some bonus tips for Classic formats:



Customize rules with formulas

Zoho Sheet allows you to create personalized rules based on formulas. For example, in a task list you can use customized formulas to highlight tasks which are nearing their due date, are already completed, or are now overdue.


 


Format your table with alternate row colors

Want to format your data table rows with colors in an alternating pattern? Conditional formatting can not only help you visualize your data but also format your table. Use the formula =MOD(ROW(),2)=0 as the rule in a Classic format and choose the fill color you want. This way, you can format your data table in an instant.




Highlight duplicate entries in your data

When a spreadsheet has data coming in from various sources, it will often contain a few errors or duplicate values. You can keep an eye on duplicate values, missing values, or errors in your data set by highlighting them with conditional formatting rules.

                                                              

Set and manage multiple rules on a range

The set of conditional formatting rules are applied from top to bottom. If you have two separate rules set on the same cell range, you can just rearrange the rules and put the one you want applied first at the top.
​
                                                

To know more about conditional formats and their use, watch our webinar video.

 

Are there any specific features you'd like to see in our future tips? Mention them in the comments below!

 

Join the Zoho Sheet community and stay updated on the latest features, interact with fellow users, and get to know the team behind Zoho Sheet. For more such exciting tips follow our Tips and Tricks forum.



    Nederlandse Hulpbronnen


      • Recent Topics

      • Error AS101 when adding new email alias

        Hi, I am trying to add apple@(mydomain).com The error AS101 is shown while I try to add the alias.
      • Meet the new Zoho Analytics: The Agentic Analytics platform

        Every major release of Zoho Analytics has changed what you can do with data. This one changes who does the work. For years, analytics meant a chain of hands. The engineer shaped the data, the analyst wrote the query, the designer built the dashboard,
      • Function failure APIs report "no failures" (204 / empty 200) while the Failures view lists real failures

        We want to monitor custom-function failures through the API so we can find and re-run failed functions quickly. We could not find a function-failures endpoint in the API reference (only webhook failures are documented), so we tried the paths that exist
      • Zoho Writer workflows now support custom stages, parallel reviews, and external approvers

        Hello everyone, Zoho Writer now lets you build your own approval chains. The pre-built workflows also get new review modes, completion criteria, and external approver support. What’s new Custom workflows: Design review and approval processes from scratch,
      • Unlock more with Linkthread's new Basic plan

        Hey everyone, Last year, we introduced Linkthread by Zoho Social with a simple idea: help users bring everything they want to share into one link. Since then, Linkthread has continued to evolve, and we’re excited to announce its next milestone—the launch
      • Rating system button not translated to Spanish + "Done"

        I've run into a issue with the new system for rating support interactions when the chat is ended: Missing Spanish translation: The button is still showing in English as "Done," even though the interface language is set to Spanish. It should display something
      • 【11/19(木)15時〜・先着5名】後回しになっているZohoの設定、一緒に進めませんか?|オンラインもくもく会

        ユーザーの皆さま、こんにちは。 コミュニティグループの中野です。 「試したい機能や設定があるけれど、日々の業務で後回しになっている」 「一人で検証していると、途中で手が止まってしまう」 「ほかのユーザーがどう運用しているか、聞いてみたい」 そんな方に向けて、11月19日(木)にオンラインの「Zoho ワークアウト」を開催します。 参加者それぞれが取り組みたいテーマを持ち寄り、設定・検証・運用改善を進める少人数の「もくもく会」です。 各自で作業しながら、必要に応じてユーザー同士で相談や情報交換ができます。
      • Connection into Cliq?

        I have the SalesIQ chat widget on my site using the Zohobot but I'm not always on and my employees don't keep it open all the time. We do have Cliq open all the time though so I'd love a way to manage those discussions directly in Cliq as they come in.
      • Multiple Topics assigned to a single Campaign

        Hello, is it possible to assign multiple Topics to a single Campaign? We frequently write a content to our subscribers that spans multiple Topics and we would like to send it to all Contacts that are subscribed to at least one of the Topics. But it looks
      • How to sync Organisation Contacts to Android / AES

        After migration form Exchange compatible server, I got Org Contacts: I've turned on EAS Organisation contacts sync. But on my phone they don't appear and there is no contacts folder to select for these contacts. Only personal contacts. They do appear
      • Zoho Campaigns - Accept Rollup Summary As Format In Use

        Hi Zoho Team, I would like to request an enhancement to the integration between Zoho CRM and Zoho Campaigns. Currently, Rollup Summary fields in Zoho CRM are available for selection during field mapping, but I am unable to map a Rollup Summary field containing
      • Is it possible to change the percentage field in zoho crm , to put 3 decimals ?

        Hello , I need to write 1,444 in the percentage field in zoho CRM. However, I've noticed that there is a limitation of 2 decimals for this field. I've found out that if I replace this field with a Decimal one (.OO), I can choose to have 3 decimals. I've
      • Save hours daily this peak season: Better Inventory & Shipping with Zoho on Easyship

        Peak season shouldn't mean losing control of your inventory just to keep up with demand. When the holiday rush hits, everything in your business gets tested at once. Orders surge, stock runs low, and shipping costs climb as customers expect faster delivery
      • How Can Zoho Desk and Knowledge Base Help Manage Technical Support for an Android TV Website?

        Hello everyone, I manage MXL TV App, an independent technology website covering Android applications, Android TV, Smart TVs, digital entertainment, installation guides, and troubleshooting. I'm exploring ways to organize technical questions and make helpful
      • Build a Legacy of Support with Zoho Desk

        Hi everyone, World Heritage Day, also known by the name International Day for Monuments and Sites, is a moment to celebrate the stories, culture, and history preserved in the monuments, landscapes, and heritage around us. At Zoho Desk, heritage is not
      • Documents greater than 40MB Preview

        hello, Documents bigger than 40 MB cannot be previewed in WorkDrive Web App or Mobile App. would it be resolved in future?
      • Issues with Zoho Sheet in Mac

        I have downloaded the Zoho App from App Store but It is failing to Save As, Open & Download Operations. App Store
      • To-do lists screwed up by update

        My app just updated, and now it's unusable for my grocery and packing lists and pretty much everything I use this app for. It used to be that when you checked a box on a to-do list, the item was automatically migrated to the bottom of the list. Then when
      • Campaign send from unverified e-dress

        L.S. I have a problem with z-Campaigns. My email (sender) address seems to be unverified: Verified domain. Sender couldn’t be verified This email is from your organization’s verified domain, but the sender couldn’t be verified. It may be an automated
      • Change default "Sort by"

        Is there a way to change the default "sort by" when searching across modules?" in Zoho CRM? Currently the default sort method is "Modified time" but i would like to utilize the second option of "relevance" as the sort by default and not have to change
      • New Search Function

        Hey Team, The search function updated in our CRM about a week ago, so I assume it was an automated update across Zoho. It no longer displays leads/deals etc in Chronological order so that the most recently created or updated is the first to display which
      • Large List on Sub-Forms

        Hi, I would like to be able to add and use the Large List on a Sub-Form, currently it doesnt appear to show up for Sub-Forms. Thanks Dan
      • Feature Request: Post-commit Subform Row Event (onRowSave / afterRowCommit) in Client Scripts

        Hello Zoho CRM Product & Engineering Team, Requested Feature: Introduce an afterRowCommit (or post-commit onRowSave) subform event in Client Scripts that fires immediately after an inline subform row has been successfully committed to the database, passing
      • #CyberSecurityAwareness - Be diligent when it comes to Widget security

        We love Widgets in Zoho CRM! And in our experience they have become an essential tool for extending the feature set and providing a rich user experience beyond standard CRM UI, functionality and integrations. BUT BEWARE... If you are thinking of adding
      • Introducing the Zoho Campaigns MCP server

        Hello everyone, We are pleased to announce that Zoho Campaigns is now available in Zoho MCP. You can now connect your Zoho Campaigns organization to AI tools such as Claude, ChatGPT, GitHub Copilot in VS Code, and Cursor, and manage your email marketing
      • Deluge {"trigger":{"workflow"}} Do we need to add the id of rules of functions or rules in the workflow ?

        Hello , I've user {"trigger":{"workflow"}} in Deluge language. In my Deluge code, in order to trigger the workflow, I've specified the id of the workflow, of the rules and of the function called by the workflow. However, Zoho CRM told me that it was not
      • Let’s Talk Recruit: Answering your hiring review’s top five questions

        Picture this, it's the final week of the month, and your hiring review is just around the corner. You already know the questions you'll be asked. Which roles have been open the longest? Why did the Product Designer pipeline go quiet after the second interview?
      • What's New in Zoho POS - October 2026

        Hello everyone, Welcome to Zoho POS’s monthly update, where we bring you the latest feature releases, enhancements, events, and more. Let’s take a quick look at the new item price override option for embedded barcodes and how it can help streamline your
      • VENDORS ARE NOT SYNCHED WITH CONTACTS IN CRM

        Hello, While the ACCOUNTS and CONTACTS (Including the primary contact) are synced with the CONTACTS module in CRM, the vendor's CONTACTS are not synced with CRM - which basically forces the users to re-enter all vendor's contacts twice and then update
      • Hide Inactive Social Sign-In Providers from Login Screen

        Hello Zoho Team, We hope you are doing well. Currently, Zoho One allows admins to configure security policies and enable or disable Social Sign-In options for third-party providers such as Apple, Google, Microsoft, LinkedIn, Yahoo, Twitter, Facebook,
      • Feature Request: Render Markdown (.md) files in Zoho Cliq

        Hi, We regularly share Markdown (.md) files in Zoho Cliq. However, when we open these files in Cliq, the content does not render as Markdown—it displays as plain text. This forces us to copy/paste the content into an external Markdown viewer to read it
      • Default value in custom multi line field

        No option to add default value in custom multi line field??
      • Backorder process review - Automating Removal of Sales Order from "On Hold" When PO is Received

        Hello Zoho Inventory Team, Currently, sales orders in On Hold status are released only when the bill for the purchase order is created. In our workflow, it would be much more efficient if the sales order could automatically move out of On Hold as soon
      • Running Balance

        Please add automatically Running balance in ledger view. Taking lot of time, every time to add manually
      • Minor Problem: Dashboard Forgets Cash vs Accrual

        The dashboard doesn't reflect my cash/accrual choice from settings, AND doesn't remember what I've set it to.
      • Map Dependency Upgrades in Zoho CRM

        Map Dependency Fields enhancements are now available across all DCs. Hello everyone, We’ve introduced a set of enhancements to Map Dependency Fields to make setup simpler, faster, and more intuitive. Map Dependency helps control how values appear across
      • Die Zoho ZUG Community Meetups sind wieder da | November 2026

        Liebe deutschsprachige Zoho Community, Es ist wieder Zeit, die Zoho Community zusammenzubringen! Unsere nächste Meetup-Reihe steht an. An zwei Terminen im November ist wieder Zeit für neue Themen, anschauliche Live-Demos und viel Raum für persönlichen
      • APIs and Webhooks in Zoho CommunitySpaces

        APIs in Zoho CommunitySpaces let you work with your members, discussions, events, and knowledge resources, so you can automate engagement workflows and extend what your community can do. What can you do with APIs? You can manage your communities and events,
      • Introducing Bigin's latest AI features, built for the way you work!

        Hi Biginners! In continuation of our AI journey that began on mobile and grew with the MCP release, we're bringing AI features right inside your Bigin web interface, where it makes the most impact for your business. At Bigin, we believe in building features
      • Rehearsing changes before deployment - Sandboxes in Zoho Projects

        Dear users, You've invariably been in these project situations - adding an additional stage to verify deliverables, revamping the approval process, adding team members with different permission sets to a sensitive project and so on. As a project owner,
      • Next Page