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 Links Workflow Automation Data Collection
                              Web Forms Enterprise Begin Data Collection
                              Interactive Forms Workplace Data Collection App
                              CRM Forms Customer Service Accessible Forms
                              Digital Forms Marketing Forms for Small Business
                              HTML Forms Education Forms for Enterprise
                              Contact Forms E-commerce Forms for any business
                              Lead Generation Forms Healthcare Forms for Startups
                              Wordpress Forms Customer onboarding Order Forms for Small Business
                              No Code Forms Construction RSVP tool for holidays
                              Free Forms Travel
                              Prefill Forms Non-Profit

                              Intake Forms Legal
                              Mobile App
                              Form Designer HR
                              Mobile Forms
                              Card Forms Food Offline Forms
                              Assign Forms Photography
                              Mobile Forms Features
                              Translate Forms Real Estate Kiosk in Mobile Forms
                              Electronic Forms Banking 
                              Notification Emails for Forms Alternatives Security & Compliance
                              Holiday Forms Google Forms alternative  GDPR
                              Form to PDF Jotform alternative HIPAA Forms
                              Email Forms
                              Encrypted Forms
                              Embeddable Forms
                              Secure Forms
                              Drag & drop form builder
                              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


                                                              • Desk Community Learning Series


                                                              • Digest


                                                              • Functions


                                                              • Meetups


                                                              • Kbase


                                                              • Resources


                                                              • Glossary


                                                              • Desk Marketplace


                                                              • MVP Corner


                                                              • Word of the Day


                                                              • Ask the Experts


                                                                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

                                                                                                                        • 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 ...
                                                                                                                        • 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. ...
                                                                                                                        • 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 ...
                                                                                                                        • Copy View Configuration

                                                                                                                          You have the option of copying the configuration of another view along with its properties. Click the three dots near the view name and from the drop-down list, select Copy a View Configuration option. The "Copy configuration from another view" ...
                                                                                                                        • Formula

                                                                                                                          A formula is an expression used to perform an operation by computing values between different fields in a table.The Formula Field in Zoho Tables allows you to compute the results of the formula entered and displays those results in that field. It ...
                                                                                                                          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