Skip to main content

Cell Styling

Cell Spanning​

You can merge cells to create a larger cell that spans multiple rows or columns. This is useful for organizing data visually.

AnyDB Edit Col Span and Row Span

  • Use the Cell Details panel to increase a cell's row or column span
  • Spanning cells hides other cells underneath (until span is removed)

Cell Styling​

Style your cells with:

AnyDB Cell Styling

  1. Font Family: Set the font family: Sans Serif, Serif, Monospace, Cursive or Barcode
  2. Font: Set the font size
  3. Font Color: Set the font color
  4. Background Color: Set the background color
  5. Alignment: Set the text alignment (Left, Center, Right)
  6. Formatting: Set the text formatting (Bold, Italic, Strikethrough, Underline)

Conditional Formatting​

You can set conditional formatting rules to change the appearance of cells based on their values. This is useful for highlighting important data or creating visual cues.

To set conditional formatting, click on the condition formatting icon on the top right of the Cell Style Panel

AnyDB Cell Conditional Formatting

In the conditional formatting panel, select "+ Add Computed Property" link to add a new conditional formatting rule.

AnyDB Conditional Formatting Prop

Now you can type in a formula to set the condition for the formatting.

For background color, the formula should return a value that can be used to set the background color of the cell. In this case, it should return a color name or a hex color code.

AnyDB Conditional Formatting Formula

For example, you can use the formula IF(CURRCELL > 100, 'red', 'green') to set the background color to red if the cell's value is greater than 100, and green otherwise.

Example:​

IF(CURRCELL > 100, 'red', 'green')

or

IF(CURRCELL>100, '#FF0000', '#00FF00')

This sets the background color based on the cell's value.

AnyDB Conditional Formatting Example 1 AnyDB Conditional Formatting Example 1

tip

CURRCELL is a special variable that refers to the current cell value being evaluated.

For more complex formulas, refer to the Formulas section for syntax and examples.