---
title: "Highlight columns and fields"
slug: "highlight-columns-and-fields"
description: "Use color to highlight worksheet columns or separate column fields."
updated: 2023-10-26T15:05:37Z
published: 2023-10-26T15:05:37Z
canonical: "docs.zilliant.com/highlight-columns-and-fields"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.zilliant.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Highlight columns and fields

Use highlighting to bring attention to important data in your worksheets, or to values that need review.

Using color, you can highlight entire worksheet columns. You can also configure a column field to be highlighted automatically with a color if the field's value matches predefined criteria. For example, you might want to highlight a field when its value exceeds or falls below a certain number.

          
          

Your custom highlighting is visible only to you. However, users with **Admin** permissions can [save a highlighting setting](/v1/docs/highlight-columns-and-fields#save-highlighting-settings-as-default) as a default worksheet setting that applies to all users.

## Highlight a column

1. In a worksheet, select Column and KPI Settings, then go to the **Columns** tab.
2. Select a column or create a new one to open **Column Settings**.
3. On the **Column Highlighting** tab, select **Highlight entire column**.
4. Select a color from the dropdown list.
5. Select **Save**.

## Conditionally highlight column fields

1. In a worksheet, select Column and KPI Settings, then go to the **Columns** tab.
2. Select a column or create a new one to open **Column Settings**.
3. On the **Column Highlighting** tab, select **Conditional highlighting**.
4. In the **Select Condition Rules** dropdown list, select a condition (for example, **Less than column** or **Is between**).
5. In the **Value** field, enter or select a value.
6. In the **Color** dropdown list, select a color.
7. Optionally select **Add condition** to define another highlighting condition.
          
          

You can apply multiple highlighting conditions to one column. A condition that is higher in the list takes priority over conditions below. Use the Drag and drop feature to reorder the priority of conditions.
8. Select **Save**.

#### Example

Your threshold for reviewing product prices is when a price falls below €10. To make it easier to identify which prices need review, configure highlighting of fields whose values are €10 or lower.

![conditional highlighting 1](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Documentation/conditional%20highlighting%201.png?sv=2026-02-06&spr=https&st=2026-11-03T13%3A47%3A39Z&se=2026-11-03T14%3A47%3A39Z&sr=c&sp=r&sig=jlSmkcydn62gz1qVA9giO8s%2BXA%2Fv0arXxu%2BCPQhIlRI%3D)

After saving the configuration, your data appears as shown in the following image. ![conditional highlighting 2.png](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Documentation/conditional%20highlighting%202.png?sv=2026-02-06&spr=https&st=2026-11-03T13%3A47%3A39Z&se=2026-11-03T14%3A47%3A39Z&sr=c&sp=r&sig=jlSmkcydn62gz1qVA9giO8s%2BXA%2Fv0arXxu%2BCPQhIlRI%3D)

Later, you decide to prioritize reviewing prices that fall below €8, as they are critical. To do this, add a **less than 8** condition. Make it the first in the list of conditions to prioritize it.

![conditional highlighting](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Documentation/conditional%20highlighting%203.png?sv=2026-02-06&spr=https&st=2026-11-03T13%3A47%3A39Z&se=2026-11-03T14%3A47%3A39Z&sr=c&sp=r&sig=jlSmkcydn62gz1qVA9giO8s%2BXA%2Fv0arXxu%2BCPQhIlRI%3D)

Now, all prices below €8 are highlighted with red and prices between €8 and €10 are highlighted with yellow.

![conditional highlighting](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Documentation/conditional%20highlighting%204.png?sv=2026-02-06&spr=https&st=2026-11-03T13%3A47%3A39Z&se=2026-11-03T14%3A47%3A39Z&sr=c&sp=r&sig=jlSmkcydn62gz1qVA9giO8s%2BXA%2Fv0arXxu%2BCPQhIlRI%3D)

If you make the **less than 8** condition second in the list, none of the fields will be highlighted with red because the **less than 10** condition takes precedence.

## Remove highlighting

To remove any highlighting applied to a column:

1. In a worksheet, select Column and KPI Settings, then go to the **Columns** tab.
2. Select the column to open **Column Settings**.
3. On the **Column Highlighting** tab, select **No highlight**.

## Save highlighting settings as default

If you have **Admin** permissions, you can apply your highlighting settings to all users of a worksheet. To do this, save them to the default worksheet settings.

1. Next to Properties, select the dropdown icon.
2. Select **Set worksheet settings as default**.
3. Select the **Column highlighting** checkbox.
4. Select **Save**.

![](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Glossary/table_60(1).png?sv=2026-02-06&spr=https&st=2026-11-03T13%3A47%3A39Z&se=2026-11-03T14%3A47%3A39Z&sr=c&sp=r&sig=jlSmkcydn62gz1qVA9giO8s%2BXA%2Fv0arXxu%2BCPQhIlRI%3D)

Column and KPI Settings

![drag_and_drop_60](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Documentation/drag_and_drop_60.png?sv=2026-02-06&spr=https&st=2026-11-03T13%3A47%3A39Z&se=2026-11-03T14%3A47%3A39Z&sr=c&sp=r&sig=jlSmkcydn62gz1qVA9giO8s%2BXA%2Fv0arXxu%2BCPQhIlRI%3D)

Drag-and-drop

![](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Glossary/settings_60.png?sv=2026-02-06&spr=https&st=2026-11-03T13%3A47%3A39Z&se=2026-11-03T14%3A47%3A39Z&sr=c&sp=r&sig=jlSmkcydn62gz1qVA9giO8s%2BXA%2Fv0arXxu%2BCPQhIlRI%3D)

Properties