SeaTable
  • Functions
  • Templates
  • Solutions
    • Marketing - – The next marketing campaign is bound to come. Nothing is easier than that.
    • Project management - – Plan, track and manage team projects from start to finish.
    • Human Resources - – Structure HR processes for new hires and onboarding.
    • Distribution - Manage your entire sales pipeline and customer relationships in one place.
    • Software development - Increase the quality and speed of your development team with SeaTable.
  • Support
    • Quick guide - – Everything you need to know to get SeaTable up and running in minutes.
    • Help area - – Find answers to your questions and get tips on how to get the most out of SeaTable.
    • Integrations - – Connect SeaTable with tools like Zapier, Integromat or n8n. Or use SeaTable's API.
    • SeaTable Blog - – Here you will find product information, news and many examples of how you can use SeaTable optimally.
  • Prices
  • Login
  • login
  • Registration
  • Menu Menu

View options

  • Filtering entries in a view
  • Link filter rules with AND and OR
  • What is the ID of the user and how can you filter with it?
  • Sorting entries in a view
  • Grouping entries in a view
  • The status-row and its functions
  • Adjust row height
  • Hide and move columns
  • Cell coloring
  • Color marking of rows
  • Lock views
  • Home
  • Help
  • Use SeaTable
  • Working with views
  • View options
  • Color marking of rows

Color marking of rows

With the help of the rows-format tool you can set colored markings at the beginning of lines. The color marking of rows serves the quick identification of certain data sets. This is not to be confused with coloring cells, which allows you to highlight individual cells.

The rows-format tool

In the view options above a table you will find the following icon:

Color Marking Tool

After clicking on the rows-format tool, you can choose between three options for color highlighting:

  • Use single selection column
  • Use rules
  • Highlight duplicates

Color marking of cells

Use single selection column

For the option Use single selection column you need a column of this type in your table. This way you can mark each row at the beginning of the row with the color of the respective option entered in the single selection column.

Color marking of cells

Create a single selection column
Learn how to create new single selection columns here.

Use rules

The Use rules option allows you to set conditions for color highlighting.

  • Click on the colored triangle symbolto change the color of the marker.

    Color marking of cells

  • Specify to which of your Columns the condition should refer to.

    Color marking of cells

  • Decide for the Condition type.

    Color marking of cells

Selection of condition types depending on the column type
Please note that what options you have to choose from in the conditions depends on the type of the selected column.

Use rule example

In this example, all rows that are marked as completed in the "Published" column are to be marked. For this purpose, the column "Published" was selected, the condition "is" was used and it was specified that the rows marked with a check mark should be marked.

Color marking of rows

Highlight duplicates

rows with one or more identical column values can be highlighted using the Highlight Duplicates option. To do this, select the column you want to check for duplicates. This way you can easily identify duplicates in your table and correct or delete them if necessary.

Highlight duplicate cells in color

How helpful was this article?
Updated on 13 January 2023
Cell coloringLock views
Contents
  • The rows-format tool
  • Use single selection column
  • Use rules
    • Use rule example
  • Highlight duplicates
SeaTable Logo

Do it like thousands of other people who use SeaTable to develop powerful processes, bring order to their data, and complete their tasks more efficiently.

SeaTable on Linkedin SeaTable on Medium.com SeaTable on Instagram SeaTable on Twitter SeaTable on Github SeaTable on YouTube SeaTable at Docker Hub

Products

  • SeaTable Cloud
  • SeaTable Dedicated
  • SeaTable Server
  • Support

Support

  • Quick guide
  • Help area
  • Templates
  • Integrations
  • Forum
  • Developer API
  • Status

Company

  • About us
  • We hire
  • Press
  • Contact
  • Blog
  • Imprint
  • Security
  • Data protection
  • Terms of use
  • EULA
Scroll up
  • Deutsch
  • Français
  • Español
  • Português
  • Русский