Column Setting - Format
In the “Format” tab, you can change the appearance style settings for column data, such as colors and icons.
[A] Preview – Displays a preview with style settings applied
[B] Foregroud Color – Set the text color of the displaying data
[C] Background Color – Set the background color of the data cell
[D] Icon - Add icon when displaying data
[E] Icon Color - Set the color of the icon to be displayed additionally
[F] Icon Align - Set the alignment of the icon to be displayed additionally (left/right)
Conditional Format Setting
By adding conditions, it is also possible to change the style to be applied according to the value of data. Click on the "Add Conditional Format" link to set a condition and set the style.
Conditional formatting first determines the values to be compared and the method of comparison. By default, "This Column" is selected in Comparing to [A], and the value in the column will be the target of the conditional comparison. You can also click the "Change" link to select other columns in the sheet as comparison targets.
Condition Comparison Method [B] automatically selects the appropriate comparison method depending on the data type of the column being compared. The following types of conditional comparison methods are available:
Equals to Values - Enumerate candidate values and compare by exactly matching them or not.
In Number Range - If the value is numerical value, specify numerical ranges and compare by checking whether the value is within that ranges or not.
In Date Range - If the value is date or datetime value, specify date ranges and compare by checking whether the value is within that ranges or not.
Checked / Unchecked - Compares conditions either the comparison value has data or not (FALSE value is regarded as empty)
Comparison in "Equals to Values"
If you choose "Equals to Values" comparison, you can define multiple pairs of matching values and their corresponding formatting. When displaying the data, the first matched formatting will be applied and displayed in the order from top to bottom.
[A] Matching Value Input - Enter the string values (separated by commas if there are more than one) that are candidates for the matching.
[B] Add Conditional Format - Insert a new conditional formatting entry between the conditions.
[C] - Deletes the given conditional formatting and matching values pair entry.
Comparison in "In Number Range"
If you choose the "In Number Range" comparison, you can define multiple ranges separated by numbers on a number line with corresponding formatting definitions. When displaying the data, the formatting for the matching range will be applied to the data.
[A] Boundary Value Input - Enter number as boundary value that splits ranges
[B] Split Range - Splits the current number range, letting you set new boundary value and formatting.
[C] Include / Exclude Boundary Value - Indicates the upper/lower bounds of the range. If the boundary value is included in the range, it is filled in; if it is not included, it is highlighted in white. Click to toggle inclusion/exclusion of the boundary value in the range.
[D] - Deletes the given conditional formatting and the corresponding number range.
Comparison in "In Date Range"
If you choose the "In Date Range" comparison, you can define multiple ranges separated by dates on a timeline with corresponding formatting definitions. When displaying the data, the formatting for the matching range will be applied to the data.
[A] Boundary Date Input - Input date as boundary value that splits ranges. In addition to specific date value (e.g., "2017/4/13"), relative date value ("This Month," "Tomorrow," "Last N Months," etc.) can also be specified.
[B] Split Range - Splits the current date range, letting you set new boundary date and formatting.
[C] Include / Exclude Boundary Value - Indicates the upper/lower bounds of the range. If the boundary value is included in the range, it is filled in; if it is not included, it is highlighted in white. Click to toggle inclusion/exclusion of the boundary value in the range.
[D] - Deletes the given conditional formatting and the corresponding date range.
When comparing datetime values in "In Date Range" comparison, they are evaluated based on the date in the local time zone.
Comparison in "Checked / Unchecked"
If you choose to the "Checked/Unchecked" comparison, you can define two types of conditions, "Checked (With Value)" and "Unchecked (No Value)", and their corresponding formatting.
Checked (With Value) - Matches if the comparison value has a value other than FALSE.
Unchecked (No Value) - Matches if the comparison value is a FALSE value or empty.
Last updated
