Color

Color

Zoho Tables lets you color-code your records with your choice of color to help you quickly identify indicative differences between records.


Record Coloring can be enabled in two ways:

  • By Single Select Field
  • By Condition





Take a look at how Record Coloring looks in different Views of Zoho Table:

Grid View

In a grid view, record colors display as colored vertical lines on the far left of the record header as part of the primary field.



The color code will also appear on the primary field ID when you expand the records.



Gallery & Kanban View

In the Gallery & Kanban View, the record coloring displays as a fold icon on the top right corner of the cards.


Gallery View


Kanban View

Calendar View

In the Calendar View, the events in dates are color-coded depending on the Single Select Field you select or the condition that is set.




Record Coloring By Single Select Field

This option will be enabled when you have at least one Single Select Field configured in your table & records will be colored according to the color in the single select field. You can also change the colors as you wish.

  1. From the view bar, click the Color option.
  2. Select the option Single Select Field to color records based on the color in the single select field.
  3. In the case of multiple single select fields, click the drop-down and choose the one of your preference. By default, it chooses the first single select field in the table.
  4. To change the color of the records, click the down arrow on the single select options
  5. Choose the desired color from the color palette
  6. To reset all your selections, click Clear all and configure the coloring from scratch. 



Record Coloring By Condition

The conditional coloring will color your records based on a set of conditions you configure. Records that comply with those conditions will automatically be assigned the specified color. You can set single or multiple conditions for coloring records.

  1. From the view bar, click the Color option.
  2. Select the Condition option. 
  3. The condition dialog box shows up with 3 selection menus


Field - You can choose the field from the drop-down to which the condition would be applied

Condition - The condition drop-down box consists of various conditions you can set for your field. They are listed below:

  • contains
  • does not contain 
  • equals 
  • not equals 
  • starts with 
  • ends with 
  • is empty 
  • is not empty 


Value: This option allows us to enter the value of the condition. Depending on this value, the data gets filtered and color-coded.




The below GIF shows how record coloring based on condition works.




Conditional Group

If you wish to add additional conditions to the same color, click ADD CONDITION

Adding more conditions to the same color will form a conditional group, which is a group of conditions connected through a combination of "AND" or "OR" or "AND/OR" conditions.



Choosing a color for your conditions

Click on the colored icon with the down arrow button on a set of conditions that open the color palette, from which you can choose your desired color for a set of conditions.




Adding new color formats

Using the color palette, you can save different color conditions. To create all new conditions, click + Add color format at the bottom of the dialog box.



Duplicating a color format

  1. To duplicate a condition along with its color format, click on the three-dot icon next to the set of conditions.
  2. Click Duplicate



Set fallback color

To give a standard color for the remaining records that do not match any of the color format conditions,
  1. Click on the Set fallback color at the bottom of the dialog box
  2. Pick a color 'For rest of the records'




      Create. Review. Publish.

      Write, edit, collaborate on, and publish documents to different content management platforms.

      Get Started Now


        Access your files securely from anywhere

          Zoho CRM Training Programs

          Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

          Zoho CRM Training
            Redefine the way you work
            with Zoho Workplace

              Zoho DataPrep Personalized Demo

              If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

              Zoho CRM Training

                Create, share, and deliver

                beautiful slides from anywhere.

                Get Started Now


                  Zoho Sign now offers specialized one-on-one training for both administrators and developers.

                  BOOK A SESSION







                              Quick LinksWorkflow AutomationData Collection
                              Web FormsRetailOnline Data Collection Tool
                              Embeddable FormsBankingBegin Data Collection
                              Interactive FormsWorkplaceData Collection App
                              CRM FormsCustomer ServiceForms for Solopreneurs
                              Digital FormsMarketingForms for Small Business
                              HTML FormsEducationForms for Enterprise
                              Contact FormsE-commerceForms for any business
                              Lead Generation FormsHealthcareForms for Startups
                              Wordpress FormsCustomer onboardingForms for Small Business
                              No Code FormsConstructionRSVP tool for holidays
                              Free FormsTravelFeatures for Order Forms
                              Prefill FormsNon-Profit
                              Forms for Government
                              Intake FormsLegal
                              Mobile App
                              Form DesignerHR
                              Mobile Forms
                              Card FormsFoodOffline Forms
                              Assign FormsPhotographyMobile Forms Features
                              Translate FormsReal EstateKiosk in Mobile Forms
                              Electronic FormsInsurance
                              Drag & drop form builder

                              Notification Emails for FormsAlternativesSecurity & Compliance
                              Holiday FormsGoogle Forms alternative GDPR
                              Form to PDFJotform alternativeHIPAA Forms
                              Email FormsWufoo alternativeEncrypted Forms
                              Accessible FormsTypeform alternativeSecure Forms

                              WCAG

                                          Create. Review. Publish.

                                          Write, edit, collaborate on, and publish documents to different content management platforms.

                                          Get Started Now






                                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                                Manage your brands on social media

                                                                  Use cases

                                                                  Make the most of Zoho Desk with the use cases.

                                                                   
                                                                    

                                                                  eBooks

                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho Desk.

                                                                   
                                                                    

                                                                  Videos

                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho Desk.

                                                                   
                                                                    

                                                                  Webinar

                                                                  Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                                   
                                                                    
                                                                  • Desk Community Learning Series


                                                                  • Meetups


                                                                  • Ask the Experts


                                                                  • Kbase


                                                                  • Resources


                                                                  • Glossary


                                                                  • Desk Marketplace


                                                                  • MVP Corner



                                                                    Zoho Sheet Resources

                                                                     

                                                                        Zoho Forms Resources


                                                                          Secure your business
                                                                          communication with Zoho Mail


                                                                          Mail on the move with
                                                                          Zoho Mail mobile application

                                                                            Stay on top of your schedule
                                                                            at all times


                                                                            Carry your calendar with you
                                                                            Anytime, anywhere




                                                                                  Zoho Sign Resources

                                                                                    Sign, Paperless!

                                                                                    Sign and send business documents on the go!

                                                                                    Get Started Now




                                                                                            Zoho TeamInbox Resources





                                                                                                      Zoho DataPrep Demo

                                                                                                      Get a personalized demo or POC

                                                                                                      REGISTER NOW


                                                                                                        Design. Discuss. Deliver.

                                                                                                        Create visually engaging stories with Zoho Show.

                                                                                                        Get Started Now









                                                                                                                            • Related Articles

                                                                                                                            • Chart

                                                                                                                              The Chart Element in the Reports feature allows you to visualize data from a table in a variety of chart formats. How to add and configure a chart element? Drag and Drop the Chart element from the left-side panel onto the report board. The ...
                                                                                                                            • KPI

                                                                                                                              The KPI (Key Performance Indicator) element provides a visual snapshot of a key metric in your report. It helps stakeholders quickly assess performance through a value, optional comparisons, and visual styling. How to add and configure a KPI element? ...
                                                                                                                            • Single Select

                                                                                                                              When there is a repetitive appearance of certain expressions in a field, you can prefer a single select field rather than manually entering the terms repeatedly. You can choose only one option from a drop-down menu with multiple predefined choices. ...
                                                                                                                            • Rating

                                                                                                                              The Rating field is to rate your records based on the priority or quality of the task. How does it work? Select the Rating field, by clicking the + icon from the field header. Your field is now created. To customize the rating field Click the ...
                                                                                                                            • Multi Select

                                                                                                                              Multiselect works the same as the single select field. You can select options from the predefined list, except that you can choose more than one option in a record. How does it work? Choose Multi Select from the list of fields available. This opens ...
                                                                                                                              Wherever you are is as good as
                                                                                                                              your workplace

                                                                                                                                Resources

                                                                                                                                Videos

                                                                                                                                Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                                eBooks

                                                                                                                                Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                                Webinars

                                                                                                                                Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                                CRM Tips

                                                                                                                                Make the most of Zoho CRM with these useful tips.



                                                                                                                                  Zoho Show Resources