Conditional Formatting lets you color-code your data for easier understanding. Formatting your data makes it easier to share with others and brings attention to the most important issues. Formatting is currently available for connected fields like Jira Status and Assignee, as well as Visor custom fields, such as drop-down fields.

There are three ways to access formatting for your fields. First, click the paint roller icon in the toolbar. By clicking the paint roller icon, the formatting menu will display all possible fields to be formatted.

The second way to access conditional formatting is to click on the field name in the header row and click "Manage Field Choices." By clicking on the field's header row, the formatting menu will automatically open to the formatting options for that specific field.

The third way to format your fields is to click directly in a cell with a choice you'd like to format, and select "Manage Field Choices."

There are a few different ways you can apply colors to the text and backgrounds of your choices. First, you can simply use the preset formatting options.

The second way to format your data is by using the the color selector.

Third, you can format your data by typing in specific HEX, RGB, and HSL numbers.

Text can also be formatted using bold, italics, underline, and strikethrough.

Sometimes, it might be helpful for you to see which records do not have any choices in a given field. In order to make these cells more visible, you can format empty cells in the same way you'd format other drop down field choices.

With toggling, you get to decide when you want to see your formatting and when you don't. This can be helpful if you'd like to temporarily highlight specific data.

Table View

Use the toggles in the formatting menu to view the formatting you've applied to your fields.

Gantt View

You are able to apply formatting to the grid and the bars separately. Note that you are only able to select one field's formatting to be applied to the bars.

Timeline View

Toggle the formatting of the bars based on the formatting you've assigned to your different fields.

In the formatting menu, use the grippers on the left side of each choice to reorder the items in a drop down. This will change the order of the choices in the drop-down field when you are working in your worksheet.

Adding additional drop-down choices for Visor fields is easy. Simply open the formatting menu and click "Manage Field" for the field you'd like to add a new choice to. Then, select "Add Another Choice" and click "Save."

Go to Visor now