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'




    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









                                            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

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      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 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

                                                                                                              • 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 ...
                                                                                                              • 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. ...
                                                                                                              • 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