Data Formatting in TrueData Sheets

format_color_fill

Data Formatting

Applies a formatting style — bold, color, fill, and more — to cells that meet a condition. This is the most flexible conditional format type, with condition categories for blank cells, numbers, text, dates, and custom formulas.

Setting Up the Rule — 5 Steps

Apply to Range

Set the range, e.g. A1:A10.

Select the Type

Set Format rules type to Data Formatting.

Pick a Condition

Choose a condition under Format rules and fill in its value.

Build the Style

Set the look under Formatting style.

Click Done

The rule is applied immediately to the range.

Format Rules

Conditions are grouped into five categories.

Is empty

Is empty · Is not empty

Number

Equal to · Not equal to · Greater than · Greater than or equal to · Less than · Less than or equal to · Between · Not between

Text

Text contains · Text does not contain · Text starts with · Text ends with · Text is exactly

Date

Date is · Date is before · Date is after

Formula

Custom formula

Formatting Style

The Preview Text bar shows exactly how matching cells will look as you build the style below it.

Bold / Italic / Underline / Strikethrough

Toggle text style on matching cells.

Font color

Text color applied to matching cells.

Fill color

Background color applied to matching cells.

help Green fill for OI unwinding, red fill for OI buildup, or bold + fill for a strike price crossing the ATM threshold are common patterns for options chain sheets.